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.0235x1 + 0.00486x2 where 21 = high-school grade point average 2 = 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 Regression 1.76209 Residual Total 9 1.88Coefficients 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 ha value is - Select your answer - + than 0.50. d. Use the t test and a = 0.05 to test Ho : B1 = 0 and Ho : B2 = 0. Use t table. For B1, the p-value is - Select your answer - # , So - Select your answer - 4 Ho : B1 = 0. For B2, the p-value is - Select your answer - , SO - Select your answer - + Ho : B2 = 0.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. v - Select your answer - There exists significant relationship. provide a good fit to the data? Explain. There exists no significant relationship. Ra value is - Select your answer - + than 0.50. d. Use the t test and a = 0.05 to test Ho : B1 = 0 and Ho : B2 = 0. Use t table. For B1, the p-value is - Select your answer - , so - Select your answer - 4 Ho : B1 = 0. For B2, the p-value is - Select your answer - +, SO - Select your answer - + Ho : B2 = 0.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. V - Select your answer - , because the Ra value is - Select your answer - $ than 0.50. Yes = 0.05 to test Ho : 1 = 0 and Ho : B2 = 0. Use t table. No Select your answer - , so - Select your answer - 4 Ho : B1 = 0. For B2, the p-value is - Select your answer - , SO - Select your answer - + Ho : B2 = 0.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 Pa value - Select your answer - than 0.50. d. Use the t test and a = 0.05 to test Ho : B1 = ( lower table. greater For B1, the p-value is - Select your answer - Ho : B1 = 0. For B2, the p-value is - Select your answer - +, SO - Select your answer - + Ho : B2 = 0.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 ha value is - Select your answer - * than 0.50. d. Use the t test and a = 0.05 to test Ho : B1 = 0 and Ho : B2 = 0. Use t table. For B1, the p-value - Select your answer - , so - Select your answer - Ho : B1 = 0. For B2, the p-value less than 0.01 , SO - Select your answer - + ) Ho : B2 = 0. between 0.01 and 0.02 between 0.02 and 0.05 between 0.05 and 0.10 Hint(s) between 0.10 and 0.20 between 0.20 and 0.40 O- Icon Key greater than 0.40Coefficients 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 ha value is - Select your answer - * than 0.50. d. Use the t test and a = 0.05 to test Ho : B1 = 0 and Ho : B2 = 0. Use t table. For B1, the p-value is - Select your answer - *, so - Select your answer - + Ho : B1 = 0. For B2, the p-value is - Select your answer - , S V - Select your answer - Ho : B2 = 0. reject do not reject Hint(s) - Icon Key