Research into the relationship between hours of study and grades shows widely different conclusions. A recent...

50.1K

Verified Solution

Question

Statistics

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
40220
50310
65350
75440
85560
105670
95700

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.

Answer & Explanation Solved by verified expert
4.3 Ratings (892 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students