Fitting a Surface By Least Squares in Microsoft® Excel

Chapter 4, Printout 4


  1. Enter the data.

    Screenshot: screenshot

  2. Compute the multiple linear regression and display related plots.

    Excel creates a new sheet in the workbook with the summary statistics, plots of residuals vs. x1, x2, and x3, and a normal probability plot.

    Screenshot (summary output): 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."

    Screenshot (plots): screenshot

    Note: you can move the charts as necessary by clicking a blank area in the chart and dragging it to a new location. Other changes can be made by double-clicking various elements in the charts.