Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 8 Regression and Correlation 321

Now you’ll add a regression line to the data.

To add a regression line:

1 Right-click any of the data points in the graph and click Add Trendline

from the menu. See Figure 8-5.

Figure 8-5

The Add

Trendline

command

list of possible

regression and

trend lines

display the

regression

equation on

the chart

display the

regression's

r^2 value

Figure 8-6
Choosing a

trend line

2 Excel displays a list of possible regression and trend lines. Verify

that the Linear regression option is selected as shown in Figure 8-6.