376 Statistical Methods
Multiple Regression
What happens when you throw all four predictors into the regression pot?To specify the model for the regression:1 Click the Male Faculty sheet tab.
2 Click the Data Analysis button from the Analysis group on the Data
tab, select Regression from the list of Analysis Tools, and click OK.
The Regression dialog box might contain the options you selected
for the previous regression.
3 Type F1:F45 in the Input Y Range text box, press Ta b, and then type
B1:E45 in the Input X Range text box.
4 Verify that the Labels checkbox is selected and that the Confi dence
Level checkbox is selected and contains a value of 95.
5 Click the New Worksheet Ply option button and type Male Faculty
Regression in the corresponding text box (replace the current con-
tents if necessary).
6 Verify that the Residuals, Standardized Residuals, Residual Plots,
and Line Fit Plots checkboxes are selected.
7 Click OK.
The fi rst portion of the summary output is shown in Figure 9-14,
with columns resized and values reformatted.Figure 9-14
Regression
output
for male
faculty data