olzbeam.blogg.se

Excel polynomial trendline equation wrong
Excel polynomial trendline equation wrong








excel polynomial trendline equation wrong

The logarithmic best-fit line is generally used to plot data that quickly increases or decreases and then levels off. Please note that an exponential trendline cannot be created for data that contains zeros or negative values.Ī good example of an exponential curve is the decay in the entire wild tiger population on the earth. This trendline type is often used in sciences, for example to visualize a human population growth or decline in wildlife populations. The exponential trendline is a curved line that illustrates a rise or fall in data values at an increasing rate, therefore the line is usually more curved at one side. And the R 2 value of 0.9855 indicates a pretty good fit of the estimated trendline values to the actual data. For example, the following linear trendline shows a steady increase in sales over 6 months.










Excel polynomial trendline equation wrong