Correlation of the GPA and SAT Data

In this activity, you will be performing a correlation analysis on the GPA and SAT data collected by Dartmouth College on 1000 students around the country. The data consists of a High School GPA, College GPA, and SAT score for each student. As is commonly perceived, the SAT scores should be an indicator of GPA performance; similarly, a high school GPA should correlate with a comparable college GPA. A multiple sample correlation will reveal any possible relationship between any of the data sets. A scatter plot would be a useful additive to the correlation in visualizing the data.

Using the data set in Excel, perform a correlation on the data to determine any correlation between the variables.

1.What are the correlation coefficients between each of the groups?
2. What does this value tell you about the relationship between them?
3. Is the coefficient great enough that the correlation could be considered effective? 4. What can explain the relationship between SAT scores and GPAs?

Original work on this document was done by Central Virginia Governor's School student Christian Neeley (Class of '98).

Copyright © 2011 Central Virginia Governor's School for Science and Technology Lynchburg, VA