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)