Question
The National Assessment for Educational Progress (NAEP) is a U.S. government organization that assesses the performance of students and schools at all levels across the
The National Assessment for Educational Progress (NAEP) is a U.S. government organization that assesses the performance of students and schools at all levels across the United States. The following table presents the percentage of eighth-grade students who were found to be proficient in mathematics, and the percentage who were found to be proficient in reading in each of the 8 states.
State | % Proficient in Reading | % Proficient in Mathematics |
California | 62 | 60 |
Texas | 71 | 76 |
New York | 77 | 71 |
Florida | 66 | 67 |
Illinois | 76 | 71 |
Ohio | 77 | 77 |
Georgia | 66 | 65 |
North Carolina | 73 | 75 |
a) Use EXCEL to construct a scatterplot of the percentage proficient in reading (x) versus the percentage proficient in Mathematics (y). Label the chart and axes titles.
b) Display the least-squares regression line on the scatterplot for predicting the percentage proficient in Mathematics from the percentage proficient in reading.
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