StatisticsExcel_MultipleRegressionAnalysis

Multiple Regression

  • When to use it: To predict the value of a dependent variable Y from a set of independent variables (X1, X2, …, Xk)

For more information about Mutiple Regression click here.

 

Example

Assume that in the thermal treatment example (from the previous section Simple Regression Analysis) one additional variable is introduced: Unit Temperature.

Hardness (\(y\)) Temp (\(x\)) U. Temp \(x2\)
49 101 848
44 115 845
46 115 847
38 140 837
43 123 844
47 107 847
41 135 840
38 135 838
47 105 846
45 110 845
43 110 844
37 135 836
44 125 845
40 132 840
39 130 839

Using Excel (Regression)


Conclusion: Both tests are statistically significant, in other words, the regression model is statistically significant. The intercept and U. Temp (X2) should be part of the model. Temp (X1) is not significiant at the 5% level.

 

Running a Multiple Regression Analysis

 

Do it yourself

Step 1: Go to "Attachments" on the bottom of this page and dowload the Excel spreadsheet.

Step 2: Follow the steps teached in the video above and solve the exercises in the Excel spredsheet dowloaded. 

Step 3: Answer the questions in the Interactive Content below.