# 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?

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?

## Answer to relevant Questions

The file S02_16.xlsx contains traffic data from 256 weekdays on four variables. Each variable lists the number of arrivals during a specific 5-minute period of the day.a. What would it mean, in the context of traffic, for ...We have indicated that if you have two categorical variables and you want to check whether they are related, the best method is to create a crosstabs, possibly with the counts expressed as percentages. But suppose both ...Solve problem 9 with pivot tables and create corresponding pivot charts. However, find only means and standard deviations, not medians. Solve problem 5 with pivot tables and create corresponding pivot charts. If you first find the quartiles of Salary and AmountSpent (by any method), is it possible to create the desired crosstabs by grouping, without recoding ...The file S03_56.xlsx lists the average salary for each NBA team from 2004 to 2009, along with the number of team wins each of these years. Answer the same questions as in the previous problem for this basketball data.Post your question