Question: The file S02 39 xlsx lists the average high school student scores

The file S02_39.xlsx lists the average high school student scores on the SAT exam by state. There are three components of the SAT: critical reading, math, and writing. These components are listed, along with their sum. The percentage of all potential students who took the SAT is also listed by state. Create correlations and scatter plots to explore the following relationships and comment on the results.
a. The relationship between the combined score and the percentage taking the exam.
b. The relationship between the critical reading and writing components.
c. The relationship between a combined verbal component and the math component.
d. The relationship between each of critical reading, math, and writing with the combined score. Are these bound to be highly correlated because the sum of the three components equals the combined score?

View Solution:

Sale on SolutionInn
  • CreatedApril 01, 2015
  • Files Included
Post your question