The admissions officer for Clearwater College developed the following estimated regression equation relating the final c

[answerhappygod]

The Admissions Officer For Clearwater College Developed The Following Estimated Regression Equation Relating The Final C 1 (67.88 KiB) Viewed 204 times

The admissions officer for Clearwater College developed the following estimated regression equation relating the final college GPA to the student's SAT mathematics score and high-school GPA. y = -1.41 +0.023521 +0.0048622 where 21 = high-school grade point average 22 = SAT mathemathics score y=final college grade point average Round test statistic values to 2 decimal places and all other values to 4 decimal places. Do not round your intermediate calculations. a. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA df SS MS F Significance F 1.76209 Regression Residual Total 9 1.88 Coefficients Standard Error t Stat P-value Intercept -1.4053 0.4848 X1 0.023467 0.0086666 X2 0.00486 0.001077 b. Using a = 0.05, test for overall significance. - Select your answer - c. Did the estimated regression equation provide a good fit to the data? Explain. - Select your answer, because the value is - Select your answer than 0.50. d. Use the t test and a= 0.05 to test H, : B1 = 0 and HoB2 = 0. Use t table. For B1, the p-value is - Select your answer - Select your answer - Ho: B1 = 0. For B2, the p-value is - Select your answer - Select your answer H :B2 = 0. so so