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

Chapter 9, Printout 4


  1. Launch Excel.

  2. Enter the data.

    Screenshot: screenshot

  3. Compute the multiple linear regression.

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

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