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.
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.
The equation for a power trendline looks like this:
y = c * x^b