Question: It is believed that GPA (grade point average, based on a four-point scale) should have a positive linear relationship with ACT scores. Given below is
It is believed that GPA (grade point average, based on a four-point scale) should have a positive linear relationship with ACT scores. Given below is the Microsoft Excel output for predicting GPA using ACT scores based a data set of eight randomly chosen students from a Big Ten university.

4. It is believed that GPA (grade point average, based on a four-point scale) should have a positive linear relationship with ACT scores. Given below is the Microsoft Excel output for predicting GPA using ACT scores based a data set of eight randomly chosen students from a Big Ten university. Regression Statistics Multiple R 0.7598 R Square 0.5774 Adjusted R Square 0.5069 Standard Error 0.2691 Observations ANOVA df SS MS F Significance F Regression 0.5940 0.5940 8.1986 0.0286 Residual Var 0.4347 0.0724 Total 1.0287 Coefficients Standard Error 1 Stat P-value Lower 95% Upper 95% Intercept 0.5681 0.9284 0.6119 0.5630 1.7036 2.8398 ACT 0.1021 0.0356 2.8633 0.0286 0.0148 0.1895 a) What is the interpretation of the coefficient of determination in this regression? b) What is the error sum of squares (SSE) of the above regression? c) What is the predicted value of GPA when ACT = 20? d) What are the decision and conclusion on testing whether there is any linear relationship at 1% level of significance between GPA and ACT scores
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
