A partial computer output from a regression analysis using Excel’s Regression tool follows. A B C D E F G 1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple R 5 R Square 0.923 6 Adjusted R Square 7 Standard Error 3.35 8 Observations 9 10 ANOVA 11 df SS MS F Significance F 12 Regression 1612 13 Residual 12 14 Total 15 16 Coefficients Standard Error t Stat P-value 17 Intercept 8.103 2.667 18 X1 7.602 2.105 19 X2 3.111 0.613 20 a. Compute the missing entries in this output.b. Usingα= .05, test for overall significance.c. Use thettest andα= .05 to testH 0:β 1 = 0 andH 0:β 2 = 0.

A partial computer output from a regression analysis using Excel’s Regression tool follows. A B C D E F G 1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple R 5 R Square 0.923 6 Adjusted R Square 7...

A partial computer output from a regression analysis using Excel’s Regression tool follows.

a. Compute the missing entries in this output.

b. Usingα= .05, test for overall significance.

c. Use thettest andα= .05 to testH
₀:β
₁ = 0 andH
₀:β
₂ = 0.

May 25, 2022