Data Analysis with Microsoft Excel: Updated for Office 2007

358 Statistical Methods

6 Click OK.

Figure 9-2

The

completed

Regression

dialog box

Excel creates a new sheet, Multiple Reg, which contains the summary

output and the residual plots.

Interpreting the Regression Output

To interpret the output, look fi rst at the analysis of variance (ANOVA) table

found in cells A10:F14. Figure 9-3 shows this range with the columns wid-

ened to display the labels and the values reformatted. The analysis of vari-

ance table shows you whether the fi tted regression model is signifi cant.

The analysis of variance table helps you choose between two hypotheses.

H 0 : The population coefficients of all six predictor variables 50

Ha: At least one of the six population coefficients 20