(2 points) Below is partial Excel output from a multiple regression: Regression
ID: 3062844 • Letter: #
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.3878 0.1504 0.0815 5.72 41 ANOVA df F |Significance F 0.106402 SS MS Regression Residual Total 37 40 214 1209 1423 Coefficients Standard Error t Stat P-value 3.7 2.68 0.0109 3-2.7 0.0104 2.10.62 0.5391 2.93.410.0016 9.9 8.1 Intercept 9.9 Suppose that the hypothesis test below is carried out: Hi At least one nonzero Find the test statistic and the corresponding p-value Test Statistic (to 2 decimal values) = p-value (to 3 decimal values) =Explanation / Answer
here MSR =SSR/df =214/3=71.3333
MSE =SSE/df =1209/37 =32.6757
hence test statistic F =2.18
p vlaue =0.107 ( please try 0.106 if this does not work)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.