Question
Just need help with part (b)

Every few years, the National Assessment of Educational Progress asks a national sample of eighth-graders to perform the same math tasks. The goal is to get an honest picture of progress in math. Suppose these are the last few national mean scores, on a scale of 0 to 500. Year 1990 1992 1996 2000 2003 2005 2008 2011 2013 Score 263 266 271 272 278 279 281 283 285 (a) Make a time plot of the mean scores, by hand. This is just a scatterplot of score against year. There is a slow linear increasing trend Score 300「 Score 300 290 290 280 280 270 270 260 260 250 Year 250 O 1990 1990 2000 2010 20 2010 Ye 2000 2020
Score 300 Score 300 290 290 280 28아 270 270 260 260 Ye 2020 Year 2020 250 1990 2000 2010 1990 2000 2010 (b) Find the regression line of mean score on time step-by-step. First calculate the mean and standard deviation of each variable and their correlation (use a calculator with these functions). Then find the equation of the least-squares line from these. (Round your answers to two decimal places.) Draw the line on your scatterplot. What percent of the year-to-year variation in scores is explained by the linear trend? (Round your answer to one decimal place.)
0 0
Add a comment Improve this question Transcribed image text
Answer #1

(a) The step-by-step instructi ons to obtain Scatter plot using Excel2010 Store the vani ables Seore(X) and Year(r) in the columns of the Excel2010 worksheet * Choose the Insert ->Scatter. *Choose the L *Write the Chart titile as Scatterplot of Score(Y) versus ayout6>Style2. Year (X) * Write the horizontal axi s title as Year[X * Write the Vertical axis title as Score,Y Select Y vari able as Score and X variable as Year in the variables box. * Click Enter The Scatterplot of Score versus Year

The scatterplot of Score vs year 290 285 280 8 275 ◆ Score 270 265 260 1 1985 1990 1995 2000 2005 2010 2015 Year

Interpretation:

The scatter plot enables that the two quantitative variables Year (X) and Score (Y) are positively linearly correlated.

The direction of the two variables is the same and the plot showing the upward linear trend. The trend is slow linear increasing trend.

------------------------------------------------------------------------------------------------------------------------------------------------

(b) The computation table for the data 1990 1992 1996 2000 2003 2005 2008 2011 2013 263 266 271 272 278 279 69169 70756 73441 73984 77284 77841 78961 80089 81225 X,f, 523370 529872 540916 544000 556834 559395 564248 569113 573705 3960100 3968064 3984016 4012009 4020025 4032064 4044121 4052169 283 285 ΣΧ,-18018 ΣΊτ 2478 ΣΧ. 36072568 ΣΥ-682750 ΣΧΊτ 496 1453 The formula for calculating the sample mean is il -1990+1992+... +2013) (18018) 2002 X 2002 Therefore, the sample mean is X 2002 The formula for calculating the sample mean is -(263+266+.. +285) (2478) 275.33333 275. 33333 Therefore, the sample mean is -275 3333

The computati on table 199026.3 1992266 1996 271 2000 272 2003 278 2005 279 2008 281 2011 283 2013 285 (x-X)(r-?) 147.9996 93

The correlati on coefficient is given by s,Sy (497) (8.154753) (7.697402) 497 (324653112-324648324) (6144750-6140484) 62.125 62.77042 0.989718 0.9897 Therefore, the correlation coefficient is r~ 10.9897

-------------------------------------------------------------------------------------------------------------------------------------------------

The formula for calculating the coefficient of slope is S. 7.697402 8.154753 0.9897178(0.943916) 0.934211 b0934211 The formula for calculating the intercept is 275.33333-(0.934211)2002 275.33333-1870.289 1594.96 a1594.96 The least-squares equati on of the simple linear regression line is -1594.96+ 0.934211X = -1594.96 + 0.93421 1X

The step-by-step instructions to obtain Scatter plot using Excel2010 * Store the vari ables ScorelX) and Year (Y in the columns of the Excel2010 worksheet. * Choose the Insert ->Scatter. K Choose the Layout6 -> Style2 *Write the Chart titile as Scatterplot of Score(Y) versus Year (X) * Write the horizontal axi s title as Year[X * Write the Vertical axis title as Score,Y * Select Y variable as Score andX variable as Year in the variables box. * By clicking the right Choose trend line-Linear Display equation on chart -> Display R* - value on chart * Click Enter The Scatterplot of Score versus Year

y = 0.9342x-1595 R2 = 0.9795 285 280 2 275 Score Linear (Score) Linear (Score) 270 265 260 1985 1990 1995 2000 2005 2010 2015 Year(X)

The Interpretation of the coefficient of determination,R^2:

The value of the coefficient of determination of the scatter plot of the simple linear regression line is R 97.95 indicates that the percentage of the variation in the dependent variable (Y) can be explained by the independent variable Year (X). The percent of the year-to-year variation in scores is explained by the linear trend.

Add a comment
Know the answer?
Add Answer to:
Just need help with part (b) Every few years, the National Assessment of Educational Progress asks...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Every few years, the National Assessment of Educational Progress asks a national sample of eighth-graders to...

    Every few years, the National Assessment of Educational Progress asks a national sample of eighth-graders to perform the same math tasks. The goal is to get an honest picture of progress in math. Suppose these are the last few national mean scores, on a scale of 0 to 500. Year 1990 1992 1996 2000 2003 2005 2008 2011 2013 Score 262 266 272 273 277 278 280 286 288 (b) Find the regression line of mean score on time step-by-step....

  • Does anybody know what I am doing wrong? Even got the equation from Excel... Every few...

    Does anybody know what I am doing wrong? Even got the equation from Excel... Every few years, the National Assessment of Educational Frogress asks a national sample of eighth-gracers to perform the same matn tasks. The g0 is to get an honest picture of progress in mธ廿. Suppose these are the last few national mean scores, on scale cr u to SOD. 2013 rear Score 265 200 280 285 287 (a] Make a time plot of the meer scores, by...

  • The National Assessment of Educational Progress (NAEP) administered a reading test to a nationwide probability sample...

    The National Assessment of Educational Progress (NAEP) administered a reading test to a nationwide probability sample of 9-year-olds in 2010. The same test was administered to an independently chosen sample of 9-year-olds in 2020. There appears to have been some improvement: in 2010, the average score was 68.3 out of 100, while in 2020 the average score was 69.0 out of 100. Or could this be explained as a chance variation? Explain your reasoning. You may assume the NAEP took...

  • The scores of 12th-grade students on the National Assessment of Educational Progress year 2000 mathematics test...

    The scores of 12th-grade students on the National Assessment of Educational Progress year 2000 mathematics test have a distribution that is approximately Normal with mean μ = 313 and standard deviation σ = 33 . Choose one 12th-grader at random. What is the probability (±±0.1, that is round to one decimal place) that his or her score is higher than 313 ?  Higher than 412 (±±0.0001; that is round to 4 decimal places)? Now choose an SRS of 16 twelfth-graders and...

  • HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data...

    HELP needed urgently....Data and question is attacted below..... Thank you in advance there is no data link fir this data it’s all in photos.... thank you i have already posted the question We were unable to transcribe this imageNo. 2 3 4 5 6 7 8 Working Sector Public Own Public Public Private Public Private Private Own Own Private Public Public Public Private 9 10 11 12 13 Public IS 16 17 18 19 20 21 22 23 24 25...

  • Given the value line: a.) what is the top line growth for 2015? b.)Bottom-Line? c.) Annual...

    Given the value line: a.) what is the top line growth for 2015? b.)Bottom-Line? c.) Annual dividen per share? d.) Current ratio in 2014? e.) % bonds of Captial structure f.) p/e ratio g.) beta h.) EBITDA % I.) Long-Debt % change 2015 We were unable to transcribe this image41.65 TO 20.1 (Media 92) ATM 1.12 ** 3.4% YAKE 1965 07 2:22. 87 3. 35.8 COCA-COLA NYSE:KO TIMELINESS 4 Lowered 70115 h: 289 29 SAFETY . 1 New 727190 LEGENDS...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT