**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 "
`y`" in cell D1; then, in cells D2-D12, 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:**`$D$1:$D$12`**Input X Range:**`$A$1:$C$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