Microsoft Office Tutorials and References
In Depth Information
Working with Trendlines
Figure 17-28 shows a chart with a power trendline added. The first element in a two-cell array
formula in E2:F2 calculates the values for The formula is b.
=LINEST(LN(B2:B11),LN(A2:A11),,TRUE)
Figure 17-28: A chart displaying a power trendline.
The following formula, in cell F3, calculates the value for c:
=EXP(F2)
Column C shows the predicted y values for each value of using the calculated values for b and
For example, the formula in cell C2 is as follows: c.
=$F$3*(A2^$E$2)
 
Search JabSto ::




Custom Search