Correlation

The director of graduate admissions at a local university is analyzing student scores on the Graduate Records Examination (GRE) and their corresponding grade point average (GPA) in graduate school. She uses a random sample of 10 recent graduates.

1. She asks you to obtain the complete simple linear correlation solution in Excel (use α=.05). [Complete means include the correct t-test in the Excel solution].
2. In Word, referring to your Excel solution, test the significance of the sample correlation [r] statistic using the correct t-test procedure. As part of your analysis, set up and define the correct null (Ho) and alternative (Ha) hypotheses in this case. What is the decision in this case (you are required to use the answer format of the course files on this topic)?
3. Correctly define the simple linear correlation coefficient [r] in this case.
4. Now, in Word, explain to the director why, given the strong, positive correlation between GRE and GPA, that, for example, a high GRE score does not really explain the subsequent high GPA in graduate school. As part of your answer, list 3 "real" factors that actually do explain both the given student’s high GRE score and his or her corresponding subsequently high GPA in graduate school.

Price: $7.83

Solution: The downloadable solution consists of 4 pages, 383 words and 8 charts.
Deliverable: Word Document