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.
Figure 17-28: A chart displaying a power trendline.
The following formula, in cell F3, calculates the value for c:
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.