Research into the relationship between hours of study and gradesshows widely different conclusions. A recent survey of graduateswho wrote the Graduate Management Admissions Test (GMAT) had thefollowing results.​
| Hours Studied ( Midpoint) | Average Score |
| 40 | 220 |
| 50 | 310 |
| 65 | 350 |
| 75 | 440 |
| 85 | 560 |
| 105 | 670 |
| 95 | 700 |
a) Run the regression analysis in Excel on this data. Includeyour output with your answer. (Note: You may calculate by hand ifyou prefer).
b) What is the regression equation for this relationship?
c) Use the regression equation to predict the average score foreach category of hours studied.
d) Plot the original data and the regression line on a scattergram. (You may use Excel).
e) How accurate is this regression at predicting GMAT scoresbased on hours studied? Explain.
f) Use the t statistic to determine whether the CorrelationCoefficient is “significant” at the 95% confidence level.
