The file S02_39.xlsx lists the average high school student scores on the SAT exam by state. There

Question:

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Analysis and Decision Making

ISBN: 978-0538476126

4th edition

Authors: Christian Albright, Wayne Winston, Christopher Zappe

Question Posted: