The file P02_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 scatterplots 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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You wonât have to worry about the quality and deadlinesOrder Paper Now
c. The relationship between a combined verbal component (the average of critical reading and writing) 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?