Question: Given here is Excel output for a multiple regression model that was developed to predict y from two independent variables, x1 and x2. Variable x2

Given here is Excel output for a multiple regression model that was developed to predict y from two independent variables, x1 and x2. Variable x2 is a dummy variable. Discuss the strength of the multiple regression model on the basis of the output. Focus on the contribution of the dummy variable. Plot x1 and y with x2 as 0, and then plot x1 and y with x2 as 1.


Given here is Excel output for a multiple regression model


Compare the two lines and discuss thedifferences.

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.623 0.388 0.341 11.744 29 ANOVA Significance df MS Regression 2 Residua 26 28 2270.11 3585.75 5855.86 1135.05 137.91 8.23 0.0017 Total P-value 6.3800 6.4 0.00000076 0.4316 0.0004 Coefficients Standard Error t Stat Intercept 41.225 1.081 -18.404 1.3530 0.80 4.5470 -4.05

Step by Step Solution

3.39 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The regression model is 41225 1081 x 1 18404 x 2 F 823 with p 0... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

243-M-S-L-R (439).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!