QUESTION 7 Use Excel to create a regression model at a confidence level of 0.95.

Question

QUESTION 7

Use Excel to create a regression model at a confidence level of 0.95. Based on your test results, pick the best conclusion.Pick the best description of the independent variables.

Both variables are significant and should remain in the model.

X1 is significant and X2 is not significant. Therefore X2 should be removed from the model.

X2 is significant and X1 is not significant. Therefore X1 should be removed from the model.

Neither variable is significant.

Both variables are significant and should remain in the model.

X1 is significant and X2 is not significant. Therefore X2 should be removed from the model.

X2 is significant and X1 is not significant. Therefore X1 should be removed from the model.

Neither variable is significant.

Online Quiz Data for Questions 6-8 Mulitivariate Linear Regression 16 29 48 28 15 37 24 32 47 13 43 12 34. 26 49 28 42 41 13 47 16 26 48 19

Explanation / Answer

The regression result :

Here P - value for X1 is greater than significance level. 0.837 > 0.05 so X1 is not significant.

P- value for X 2 is not greater than significance level 0.05. 0.000532 < 0.05. So X1 is significant here.

So, Option C is correct here. X2 is significant and X1 is not significant. Therefore X1 should be removed from the model.

SUMMARY OUTPUT Regression Statistics Multiple R 0.919204 R Square 0.844935 Adjusted R Square 0.800631 Standard Error 6.821974 Observations 10 ANOVA df SS MS F Significance F Regression 2 1775.125 887.5623 19.07123 0.001468 Residual 7 325.7753 46.53933 Total 9 2100.9 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 5.045151 8.698264 0.580018 0.580084 -15.523 25.61328 -15.523 25.61328 x1 -0.05127 0.241343 -0.21245 0.837807 -0.62196 0.519412 -0.62196 0.519412 x2 0.887973 0.147521 6.019317 0.000532 0.539142 1.236804 0.539142 1.236804

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.