# Factorial Analysis Using Multiple Linear Regression (Without Interactions) in Microsoft® Excel

## Chapter 9, Printout 5

1. Launch Excel.

2. Enter the data.

• Type "xa1" in cell A1; then, in cells A2-A12, enter the 11 values for xa1 from the xA1 column of Table 9.20 (p. 709).

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 xA2 column of Table 9.20.

• Type "xb1" in cell C1; then, in cells C2-C12, enter the 11 values for xb1 from the xB1 column of the table.

• Type "y" in cell D1; then, in cells D2-D12, enter the 11 y values from the y column in Table 9.20.

Screenshot:

3. Compute the multiple linear regression.

• Select "Tools --> Data Analysis."

• In the dialog that follows, select "Regression" from the list of options.

Screenshot:

• 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

Screenshot:

• Click "OK."

Excel creates a new sheet in the workbook with the summary information.

Screenshot:

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."