Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Education reform is one of the most hotly debated subjects on both state and national policymakers list of socioeconomic topics, Consider a linear regression model

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Education reform is one of the most hotly debated subjects on both state and national policymakers list of socioeconomic topics, Consider a linear regression model that relates school expenditures and familly background to student performance in Massachus using 224 school districts. The response variable is the mean score on the MCAS (Massachusetts Comprehensive Assessment System) exam given to 10th graders. Four predictor variables are used: (1) STR is the student-to-teacher ratio in % (2) TSAL is the average teacher's salary in $1.000s, (3) INC is the median household income in $1,000s, and (4) SGL is the percentage of single-pa households. A portion of the data is shown in the accompanying table, Score 227.00 230.67 STR 19.00 17.90 1 19.20 TSAL 14.01 40.17 INC 48.89 43.91 SGL 4.70 4.60 1 5.10 230.67 44.79 47.64 Click here for the Excel Data File a. For each predictor variable, discuss whether it is likely to have a positive or negative influence on Score Effect On Score Predictor Variable STR TSAL INC SGL E F D INC B 1 Score STR 2 227.00 19.00 3 230.67 17.90 4 233.33 17.50 5 240.00 17.10 6 233.33 16.80 7 240.00 17.30 8 225.33 20.50 9 236.33 15.60 10 227.00 15.50 11 230.00 11.40 12 227.67 17.60 13 241.67 14.80 14 236.33 17.90 15 226.33 19.60 16 243.67 17.30 17 230.00 17.00 18 233.67 19.30 19 216.33 27.00 20 233.00 18.70 21 235.00 17.10 22 217.33 19.10 23 242.00 15.80 24 235.00 13.50 25 228.00 13.90 26 233.33 16.90 27 225,33 17.60 28 232.67 12.00 29 237.00 17.20 30 220.33 21.00 31 220.67 17.10 32 227.00 18.50 33 244.67 15.70 34 231.33 16.90 35 230.33 17.60 36 230.33 16.60 10 MCAS TSAL 44.01 40.17 36.62 47.98 45.50 40.56 40.51 44.80 29.86 29.11 44.33 43.93 35.53 42.81 49.56 40.65 36.64 46.48 40.56 47.58 46.21 45.06 47.44 50.45 45.79 42.41 44.65 46.96 41.12 37.38 38.80 43.07 45.35 34.88 42.07 48.89 43.91 44.55 70.76 52.75 57.05 43.25 46.00 49.57 32.94 40.30 64.54 44.00 50.68 61.05 48.04 53.30 34.38 38.41 51.92 38.54 61.80 60.32 39.99 62.47 41.99 36.96 59.37 29.04 35.56 40.14 74.31 51.51 39.76 52.55 SGL 4.70 4.60 6.80 4.00 3.30 4.60 5.80 3.50 4.00 7.40 6.20 3.50 5.80 4.80 3.10 5.90 3.90 9.00 5.10 4.10 10.60 3.70 4.30 5.70 3.20 5.30 2.50 4.10 13.40 7.20 5.90 3.30 4.20 4.50 4.60 A AA 10 A1 X Score F B 36 230.33 16.60 37 227.33 16.10 38 230.00 17.60 39 241.67 18.00 40 231.00 19.30 41 226.00 15.80 42 235.67 17.90 43 232.33 19.40 44 223.33 17.80 45 222.67 16.60 46 219.00 16.70 47 227.33 18.50 48 221.67 19.20 49 232.67 17.30 50 232.00 14.90 51 233.67 14.00 52 227.33 19.80 53 234.00 17.00 54 228.33 17.30 55 240.33 15.10 56 228.33 15.70 57 238.67 16.50 58 239.33 16.70 59 243.00 16.70 60 240.00 15.60 61 239.33 14.20 62 225.00 21.40 63 241.33 16.90 64 226.00 21.30 65 238.33 17.80 66 217.00 16.40 67 231.67 17.90 68 239.67 17.40 69 231.00 17.40 70 226.67 16.30 71 234.33 16.70 BE 10 MCAS 42.07 36.97 44.83 48.01 46.54 37.74 40.58 46.56 40.03 38.98 39.13 44.45 37.15 43.53 35.08 41.00 36.14 38.33 37.22 42.72 34.34 32.65 46.58 41.87 42.91 31.91 40.52 50.97 43.92 37.38 38.39 43.45 41.10 43.10 45.65 43.39 AE D 52.55 43.40 48.51 68.58 47.46 39.83 47.45 56.79 37.40 36.51 28.97 40.66 33.36 52.51 53.27 54.63 35.43 50.93 39.83 47.40 35.36 44.82 59.47 47.48 35.04 46.82 43.21 66.39 43.95 62.71 29.37 51.12 62.26 51.70 42.73 52.28 AN E 4.60 4.30 4.70 4.60 5.20 5.20 3.80 4.00 6.60 4.50 9.10 6.70 8.90 5.20 5.20 4.40 7.50 3.40 5.60 4.40 8.80 2.60 2.90 3.60 4.40 3.20 7.30 3.70 4.40 3.90 15.90 4.50 3.40 4.10 6.50 4.70 Ready Type here to search 70 226.67 16.30 71 234.33 16.70 72 215.33 21.40 73 236.33 13.30 74 230.67 18.40 75 246.33 14.50 76 223.00 20.80 77 245.00 15.40 78 235.67 16.00 79 238.67 15.20 80 221.33 21.50 81 225.00 18.00 82 231.67 19.10 83 220.00 20.50 84 237.33 16.30 85 226,67 18.40 86 237.00 14.50 87 234.00 17.50 88 242.33 16.00 89 232.33 17.90 90 232.00 16.80 91 225.33 18.20 92 231.33 17.20 93 247.00 16.60 94 222.00 16.30 95 240.00 17.40 96 232.33 17.30 97 224.33 21.50 98 227.67 21.60 99 231.67 13.10 100 235.67 19.60 101 230.67 19.00 238.00 18.80 103 233.33 18.30 104 232.33 8.90 105 239.33 17.00 11 The MCAS 45.65 43.39 44.25 40.16 39.51 41.95 38.35 55.10 41.38 43.91 41.72 40.31 44,07 42.93 48.42 46.75 40.04 38.51 38.87 48.76 41.62 39.76 41.27 46.79 43.53 41.94 45.00 39.18 42.67 41.22 46.55 45.55 41.04 39.98 37.00 45.95 42.73 52.28 26.40 42.36 46.70 44.23 41.93 76.41 55.31 70.13 35.14 40.91 49.63 35.83 64.20 42.10 66.02 53.78 65.02 47.31 55.52 34.59 50.87 73.52 45.53 59.86 53.87 44.90 41.42 45.28 45.13 54.77 61.96 39.60 49.21 56.00 CA 6.50 4.70 17.40 5.40 4.30 3.60 5.40 3.10 3.70 2.80 10.60 3.80 3.30 10.20 2.40 5.60 4.00 5.30 3.30 5.10 5.30 7.20 5.10 2.90 4.00 4.80 3.70 5.80 8.20 6.50 4.50 4.10 3.20 4.50 3.80 3.50 102 Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Telecom Audit

Authors: M S. Mastel

1st Edition

0071410546, 9780071410540

More Books

Students also viewed these Accounting questions