50C Elementary Statistical Methods CourseworkTest Run a regression analysis on t
ID: 2946073 • Letter: 5
Question
50C Elementary Statistical Methods CourseworkTest Run a regression analysis on the following data set, where y is the final grade in a math class and z is the average number of hours the student spent working on math each week. hours/weeK Grade 4 48.6 55.6 62 52 46.4 63.8 65.4 76.2 83.2 1797.8 4 7 13 13 State the regression equation y-m x + b, with constants accurate to two decimal places. Preview What is the predicted value for the final grade when a student spends an average of 6 hours each week on math? Grade Round to 1 decimal place Get help: Video Points possible: 1 This is attempt 1 of 1Explanation / Answer
Following is the output of regression analysis generated by excel:
The regression line is:
y' = 44.78+2.71x
The predicted value for the final grade for x=6 is
y' = 44.78+2.71*6 = 61.04
Answer: 61.0
SUMMARY OUTPUT Regression Statistics Multiple R 0.764809731 R Square 0.584933925 Adjusted R Square 0.533050666 Standard Error 11.19435734 Observations 10 ANOVA df SS MS F Significance F Regression 1 1412.790909 1412.790909 11.27403968 0.009965979 Residual 8 1002.509091 125.3136364 Total 9 2415.3 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 44.78181818 7.010633684 6.387699058 0.000211894 28.61526793 60.94836843 x 2.709090909 0.806833272 3.357683678 0.009965979 0.848530048 4.56965177