Microsoft Office Tutorials and References
In Depth Information
Exponential trendline
Figure 5-12: A chart displaying a power trendline
Exponential trendline
An exponential trendline is used for data that rises or falls at an increasing rate. An
exponential trendline appears as a straight line on a chart with a logarithmic y-axis
scale and a linear x-axis scale. As with the power trendline, the exponential
trendline does not work with data that contains 0 or negative values. The equation for an
exponential trendline looks like this:
y = c * EXP(b * x)
Figure 5-13 shows a chart with an exponential trendline added. The value for c
is calculated in cell E2, which contains this formula:
=EXP(INDEX(LINEST(LN(B2:B11),A2:A11),1,2))
Cell F2 contains this formula, which calculates the value for b:
=INDEX(LINEST(LN(B2:B11),A2:A11),1)
Column C shows the predicted y values for each value of x, using the calculated
values for b and c. For example, the formula in cell C2 is
=\$E\$2*EXP(\$F\$2*A2)
Search JabSto ::

Custom Search