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 ten most populous states. Use excels to find:
a) Construct a scatterplot with reading proficiency on the horizontal axis and math proficiency on the
vertical axis. Is there a linear relationship?
b)
Compute the correlation between reading proficiency and math proficiency. Is the linear association
positive or negative? Weak or strong?
State
Percentage Proficient in Reading
Percentage Proficient in Mathematics
California
60
59
Texas
73
78
New York
75
70
Florida
66
68
Illinois
75
70
Pennsylvania
79
77
Ohio
79
76
Michigan
73
66
Georgia
67
64
North Carolina
71
73
Question # 3
From the above table, Use excels to find:
a)
Compute the least-squares regression line for predicting math proficiency from reading
proficiency.
b)
Interpretate the
least-squares regression line in part a.
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