Problem 5 Research into the relationship between hours of study and grades shows widely different conclusions....

90.2K

Verified Solution

Question

Statistics

Problem 5

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 thefollowingresults.         

Hours

Studied           Average

(Midpoint)      Score

40                   200

50                   290

65                   335

75                   445

85                   530

105                 650

95                   690

           

  1. Run the regression analysis in Excel on this data. Include youroutput with your answer. (Note: You may calculate by hand if youprefer).
  2. What is the regression equation for this relationship?
  3. Use the regression equation to predict the average score foreach category of hours studied.
  4. Plot the original data and the regression line on a scattergram. (You may use Excel).
  5. How accurate is this regression at predicting GMAT scores basedon hours studied? Explain.
  6. Use the t statistic to determine whether the CorrelationCoefficient is “significant” at the 95% confidence level.

Answer & Explanation Solved by verified expert
4.4 Ratings (656 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