(2 points) Below is partial Excel output from a multiple regression: Regression

Question

(2 points) Below is partial Excel output from a multiple regression: Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.3917 0.1534 0.0929 5.41 46 ANOVA F Significance F 0.0695786 df SS MS egression Residual Total 42 45 223 1231 1454 Coefficients Standard Errort Sta P-value 1 0.323 2.4 |-2.67 | 0.0107 2.9 1.140.2607 3.5 |-2.71 | 0.0097 -3.4 -6.4 3.3 -9.5 Intercept 3.4 x3 Suppose that the hypothesis test below is carried out: HAt Find the test statistic and the corresponding p-value Test Statistic (to 2 decimal values)- t least one nonzero p-Value (to 3 decimal values)-

Explanation / Answer

Ans:

Complete the table:

MS(regression)=223/3=74.333

MS(residual)=1231/42=29.309

Test statistic:

F=MS(regression)/MS(error)=74.333/29.309=2.54

p-value=FDIST(2.54,3,42)=0.070

*(p-value=0.069,when F is rounded off to 2 decimal)

DF SS MS F Significance F Regression 3 223 74.33333 2.54 0.0695786 Residual 42 1231 29.30952 Total 45 1454

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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