**Launch Excel.****Enter the data.**- Type "
`xa1`" in cell A1; then, in cells A2-A12, enter the 11 values for xa1 from the*x*column of Table 9.20 (p. 709).^{A}_{1}**Note:**you will have to enter each xa1 value once for each corresponding y-value in Table 9.20. The same is true for xa2 and xb1. See the screenshot at the end of this step for clarification if necessary. - Type "
`xa2`" in cell B1; then, in cells B2-B12, enter the 11 values for xa2 from the*x*column of Table 9.20.^{A}_{2} - Type "
`xb1`" in cell C1; then, in cells C2-C12, enter the 11 values for xb1 from the*x*column of the table.^{B}_{1} - Type "
`xa1*xb1`" in cell D1. - In cell D2, enter "
`=A2*C2`" - Select cells D2-D12.
- Select
**"Edit --> Fill --> Down."** - Type "
`xa2*xb1`" in cell E1. - In cell E2, enter "
`=B2*C2`" - Select cells E2-E12.
- Select
**"Edit --> Fill --> Down."** - Type "
`y`" in cell F1; then, in cells F2-F12, enter the 11 y values from the*y*column in Table 9.20.

*Screenshot:*- Type "
**Compute the multiple linear regression.**- Select
**"Tools --> Data Analysis."** - In the dialog that follows, select
**"Regression"**from the list of options. - Click
**"OK."** - Fill out the resulting dialog box as follows:
Input Type Label Value **Input Y Range:**`$F$1:$F$12`**Input X Range:**`$A$1:$E$12`**Labels***checked***Constant is Zero***unchecked***Confidence Level***unchecked***New Worksheet Ply:***selected***New Worksheet Ply:****Residuals***unchecked***Residual Plots***unchecked***Standardized Residuals***unchecked***Line Fit Plots***unchecked***Normal Probability Plots***unchecked* - Click
**"OK."**

*Excel creates a new sheet in the workbook with the summary information.***Note:**you can resize all columns to fit their contents by selecting all the cells you want to resize, then selecting**"Format --> Column --> Autofit Selection."**- Select