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.
R-squared value measures the trendline reliability – the nearer R 2 is to 1, the better the trendline fits the data.īelow, you will find a brief description of each trendline type with chart examples. 
Trendline equation is a formula that finds a line that best fits the data points. 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. Notice the pattern in the two preceding sets of formulas.It is very easy to add a trendline in Excel. Logarithmic Trendline Equation: y = (c \* LN(x)) - bĬ: =EXP(INDEX(LINEST(LN(y),LN(x),),1,2))Įxponential Trendline Equation: y = c \*e ^(b \* x)Ģnd Order Polynomial Trendline Equation: y = (c2 \* x^2) + (c1 \* x ^1) + bģrd Order Polynomial Trendline Equation: y = (c3 \* x^3) + (c2 \* x^2) + (c1 \* x^1) + b Linear Trendline Equation: y = m \* x + b These equations assume that your sheet has two named ranges: x and y. You can then use these formulas to calculate predicted y values for give values of x. This tip describes how to create formulas that generate the trendline coefficients. When you add a trendline to a chart, Excel provides an option to display the trendline equation in the chart.
0 kommentar(er)
