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.
a. Create a histogram for each of the numeric variables. Are these distributions essentially symmetric or are they skewed?
b. Compare the two “Pct taking” columns. Does anything stand out?
c. Find summary statistics for each of the variables. Which is the most appropriate measure of central tendency? Why?
d. For the SAT, the Total score is the sum of the ERW and Math scores. How does the mean of the Total variable relate to the means of the ERW and Math variables? Is the same true for medians?