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

Question

QUESTION 6

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 overall model.

The overall model is not significant because the correlation is too low.

The overall model is significant because the correlation is high.

The overall model is significant because the signfiicance F = .001468 is less than alpha = .05.

The overall model is not significant because the F = 19.07123 is greater than alpha = .05.

The overall model is not significant because the correlation is too low.

The overall model is significant because the correlation is high.

The overall model is significant because the signfiicance F = .001468 is less than alpha = .05.

The overall model is not significant because the F = 19.07123 is greater than alpha = .05.

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

here below is the output from excel data analysis for regression on above data:

hence correct option is :

The overall model is significant because the signfiicance F = .001468 is less than alpha = .05.

Regression Statistics Multiple R 0.919203644 R Square 0.84493534 Adjusted R Square 0.800631151 Standard Error 6.821974413 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

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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