Microsoft Office Tutorials and References

In Depth Information

**Working with Trendlines**

Figure 17-30:
A chart displaying a polynomial trendline.

Column C shows the predicted
y values for each value of
using the calculated values for
b and

the three
c coefficients. For example, the formula in cell C2 is

=($F$2*A2^3)+($G$2*A2^2)+($H$2*A2)+$I$2