Question

In: Statistics and Probability

Problem 5 (14 Marks) Research into the relationship between hours of study and grades shows widely...

Problem 5

Research into the relationship between hours of study and grades shows widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following results.         

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 your output with your answer. (Note: You may calculate by hand if you prefer).
  2. What is the regression equation for this relationship?
  3. Use the regression equation to predict the average score for each category of hours studied.
  4. Plot the original data and the regression line on a scatter gram. (You may use Excel).
  5. How accurate is this regression at predicting GMAT scores based on hours studied? Explain.
  6. Use the t statistic to determine whether the Correlation Coefficient is “significant” at the 95% confidence level.

Solutions

Expert Solution


Related Solutions

Research into the relationship between hours of study and grades shows widely different conclusions. A recent...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following results.        Hours Studied            Average (Midpoint)      Score 40                    210 50                    300 65                    345 75                    455 85                    540 105                  660 95                    700             Run the regression analysis in Excel on this data. Include your output with your answer. (Note: You may calculate by hand if you prefer). What is the regression equation...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following results. Hours Studied Average (Midpoint) Score 40 210 50 300 65 345 75 455 85 540 105 660 95 700 Run the regression analysis in Excel on this data. Include your output with your answer. (Note: You may calculate by hand if you prefer). What is the regression equation for...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following results. Hours Studied [Average Score] (Midpoint)   40 220 50 310 65 350 75 440 85 560 105 670 95 700 a) Run the regression analysis in Excel on this data. Include your output with your answer. (Note: You may calculate by hand if you prefer). b) What is the regression...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent...
Research into the relationship between hours of study and grades shows widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following 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. Include your output with your answer. (Note: You may calculate by hand if you prefer). b) What is the...
14. A study has shown that a good model for the relationship between X and Y...
14. A study has shown that a good model for the relationship between X and Y , the first and second year batting averages of a randomly chosen major league baseball player, is given by the equation Y = .159 + .4X + e, where e is a normal random variable with mean 0. That is, the model is a simple linear regression with a regression toward the mean. (a) If a player’s batting average is .200 in his first...
Propose a research study that examines the relationship between population growth and health. Identify the research...
Propose a research study that examines the relationship between population growth and health. Identify the research topic, include discussion of how you would frame your research question and what theory or theories you would use, select an appropriate research methodology, weigh any ethical implications, and discuss any challenges or threats to data collection, reliability, or validity that may arise.
Imagine you were conducting research on the relationship between academic performance (e.g., better grades) and different...
Imagine you were conducting research on the relationship between academic performance (e.g., better grades) and different levels of loudness of music (interval scale) while studying. How would you design the study using a correlational design? How would you design the study using a quasi-experimental design? How would you design the study using an experimental design?
The international rice research institute in the Philippines conducted a study of the relationship between and...
The international rice research institute in the Philippines conducted a study of the relationship between and the yield of rice and the amount of nitrogen fertilizer used when growing the rice. A number of small plots of land (all the same size) were used in the study with varying amounts of fertilizer from one plot to the next. When the rice is harvested, the yield (in ounces of rice) was measured and related to the amount (in ounces) of nitrogen...
A professor is studying to see if there is a relationship between the grades and gender...
A professor is studying to see if there is a relationship between the grades and gender of his students. He picks a random sample of his students and notes their grades (A, B, or C) and their gender (male or female). He finds that: 28% are A students. 58% are B students. 62% of his students are female. Of those who are female, one-third are A students. Of those who are B students, three-fifths are female students. What percentage of...
A professor is studying to see if there is a relationship between the grades and gender...
A professor is studying to see if there is a relationship between the grades and gender of his students. He picks a random sample of his students and notes their grades (A, B, or C) and their gender (male or female). He finds that: 28% are A students. 58% are B students. 62% of his students are female. Of those who are female, one-third are A students. Of those who are B students, three-fifths are female students. What percentage of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT