Microsoft Office Tutorials and References
In Depth Information
Getting the trendline values
Figure 5-10: Column D uses the FORECAST
function to calculate points on a trendline.
Calculating slope, y-intercept, and R-squared
As described in this chapter, you can use the FORECAST function to calculate the
points on a linear trendline and forecast other values. Alternatively, you can calculate
the slope and y-intercept for the best-fit line, and then use these values to calculate
the data points.