- 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.
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\)|
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.