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.
Typically, a linear trendline describes a continuous rise or fall over time.įor example, the following linear trendline shows a steady increase in sales over 6 months. The linear trend line is best to be used with linear data sets when the data points in a chart resemble a straight line.
Additionally, Microsoft Excel allows displaying a trendline equation and R-squared value in a chart: When adding a trendline in Excel, you have 6 different options to choose from. Excel trendline equation is wrong – reasons and fixes.It is very easy to add a trendline in Excel.