The file P02_39.xlsx contains SAT and ACT test scores by state for high school graduates of the
Question:
The file P02_39.xlsx contains SAT and ACT test scores by state for high school graduates of the 2016– 2017 school year. These are broken down by reading/writing and math/science scores. The file also lists the percentages of students taking these two tests by state. Create correlations and scatterplots to explore the following relationships and comment on the results.
a. The relationship between the total SAT score and the percentage taking the SAT exam.
b. The relationship between the ERW and Math components of the SAT exam.
c. The relationship between the composite ACT score and the percentage taking the ACT exam.
d. The relationship between the four components of the ACT exam.
Step by Step Answer:
Business Analytics Data Analysis And Decision Making
ISBN: 9780357109953
7th Edition
Authors: S. Christian Albright, Wayne L. Winston