Microsoft Office Tutorials and References

In Depth Information

**Working with Trendlines**

Figure 17-27:
A chart displaying a logarithmic trendline.

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

For example, the formula in cell C2 is
c.

=($E$2*LN(A2))+$F$2

As you can see, a logarithmic trendline does not provide a good fit for this data. The R-square

value is low, and the trendline does not match the data.

Power trendline

The equation for a power trendline looks like this:

y = c * x^b