Suppose we want to know if the number of hours spent studying and the number of prep exams taken affects the score that a student receives on a certain college entrance exam To explore this relationship, we can perform multiple linear regression using hours studied and prep exams taken as predictor variables and exam score as a response variable. The following screenshot shows the regression output of this model in Excel: D G SUMMARY OUTPUT H Regression Statistics Multiple R 0.857 R Square 0.734 Adjusted R Square 0.703 Standard Error 5.366 Observations 20 ANOVA of Regression Residual Total 2 17 19 55 MS 1350.76 675.38 489.44 28.79 1840.20 F Significance F 23.46 0.00 Intercept hours prep exams Coefficients Standard Error Stat P value 67.67 2.82 24.03 0.00 0.90 6.18 0.00 -0.60 0.91 -0.66 0.52 5.56 Lower 95% Upper 95% 61.73 73.61 3.66 7.45 -2.53 1.33 

Question: How much of the variation in exam score is explained by hours and prep exams? 0.734 5.56 0.857 

 

Answer rating: 100% (QA)

The coefficient of determination R2 also known as the Rsquared value represen... View the full answer