The Admissions Officer For Clearwater College Developed The Following Estimated Regression Equation Relating The Final C 1 (31.63 KiB) Viewed 30 times
The Admissions Officer For Clearwater College Developed The Following Estimated Regression Equation Relating The Final C 2 (34.43 KiB) Viewed 30 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. 9-1.41 +0.02351 +0.004862 where #1 high-school grade point average ₂ 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 MS Significance F Regression Recidual .9681 .9373 .9194 .1298 10 df ** SS 1.76209 xx
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 SS MS F Significance F Regression 1.76209 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. There exists significant relationship. v c. Did the estimated regression equation provide a good fit to the data? Explain. because the R value is greater Yes .9681 .9373 .9194 .1298 10 df x *** than 0.50.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!