Chapter 9 Multiple Regression 357You can use the Analysis ToolPak Regression command to perform a
multiple regression on the data, but the predictor variables must occupy a
contiguous range. You will be using columns A, B, C, D, E, and G as your
predictor variables, so you need to move column G, Gender Code, next to
columns A:E.
To move column G next to columns A:E:1 Click the G column header to select the entire column.
2 Right-click the selection to open the shortcut menu; then click Cut.
3 Click the F column header.
4 Right-click the selection to open the shortcut menu; then click Insert
Cut Cells. You can now identify the contiguous range of columns
A:F as your predictor variables.
To perform a multiple regression on the calculus score based on the pre-
dictor variables Calc HS, ACT Math, Alg Place, Alg2 Grade, HS Rank, and
Gender Code, use the Regression command found in the Analysis ToolPak
provided with Excel.
To perform the multiple regression:1 Click Data Analysis from the Analysis group on the Data tab, select
Regression from the Analysis Tools list box, and click OK.
2 Type H1:H81 in the Input Y Range text box, press Ta b, and then type
A1:F81 in the Input X Range text box.
3 Click the Labels checkbox and the Confi dence Level checkbox to se-
lect them, and then verify that the Confi dence Level box contains 95.
4 Click the New Worksheet Ply option button, click the corresponding
text box, and then type Multiple Reg.
5 Click the Residuals, Standardized Residuals, Residual Plots, and
Line Fit Plots checkboxes to select them. Your Regression dialog box
should look like Figure 9-2.