Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The file P02_39.xisx contains SAT and ACT test scores by state for high school graduates of the 2016-2017 school year. These are broken down by
The file P02_39.xisx 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. Round your answers to three decimal places, if necessary. If your answer is a negative value, enter minus sign. a. The relationship between the total SAT score and the percentage taking the SAT exam. (i) SAT Total vs Pct taking SAT (ii) SAT Total vs Pct taking SAT 1400 1400 1300 1300 1200 1200 1100 1100 1000 1000 900 900 800 800 0% 20% 40% 60% 80% 100% 120% 0% 20% 40% 60% 80% 100% 120% (iii) SAT Total vs Pct taking SAT (iv) SAT Total vs Pct taking SAT 1400 1400 1300 1300 1200 1200 1100 1100 1000 1000 900 900 800 800 0% 20% 40% 60% 80% 100% 120% 0% 20% 40% 60% 80% 100% 120% Graph (i) v x Correlation is 0.7 X
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started