(1 point) Below is Excel output from a multiple regression: Regression Statistic

Question

(1 point) Below is Excel output from a multiple regression: Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.6295 0.3963 0.3474 6.04 41 ANOVA F Significance F 8.10.000284156 df Regression Residual Total MS 887295.67 1351 36.51 37 40 2238 Intercept xl x2 x3 Coefficients Standard Error Sta P-value 2.43.33 0.002 3.6 0.81 0.4231 -2 0.0529 3.6-0.69 0.4945 2.9 6.8 -2.5 3.4 Suppose that the hypothesis test below is carried out: Ho: 2-6 Find the test statistic and the corresponding p-value Test Statistic (to 2 decimal places) = p-value (to 3 decimal places) =

Explanation / Answer

From the excel output,

Test statistic is t stat of x2 i.e. -2

P- value is 0.0529.

Since p - value is greater than 0.05, we fail to reject Ho

So there beta 2 is not significant at 5% significance level

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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