Microsoft Office Tutorials and References
In Depth Information
Working with Trendlines
Exponential trendline
The equation for an exponential trendline looks like this:
y = c * EXP(b * x)
Figure 17-29 shows a chart with an exponential trendline added. The first element in a two-cell
array formula in F2:G2 calculates the values for The formula is b.
{=LINEST(LN(B2:B11),A2:A11)}
Figure 17-29: A chart displaying an exponential trendline.
 
Search JabSto ::




Custom Search