Data Analysis with Microsoft Excel: Updated for Office 2007

324 Statistical Methods

7 Click the New Worksheet Ply option button and type Regression

Statistics in the accompanying text box.

8 Click all four of the Residuals checkboxes.

Your Regression dialog box should appear as shown in Figure 8-8.

Note that we did not select the Normal Probability Plots checkbox.

This option creates a normal plot of the dependent variable. In most

situations, this plot is not needed for regression analysis.

range contains

a row of

column labels

display residuals
from the regression

Figure 8-8

The

Regression

dialog box

9 Click OK.

Excel generates the output shown in Figure 8-9.