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.

Continued