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 policy makers' list of socioeconomic topics. Consider a linear regression

Education reform is one of the most hotly debated subjects on both state and national policy makers' list of socioeconomic topics. Consider a linear regression model that relates school expenditures and family background to student performance in Massachusetts using 224 school districts. The response variable is the mean score on the MCAS (Massachusetts Comprehensive Assessment System) exam given to 10th graders. Four explanatory variables are used: (1) STR is the student-to-teacher ratio, (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-parent households. A portion of the data is shown in the accompanying table.

SCORE

STR

TSAL

INC

SGL

227.00

19.00

44.01

48.89

4.70

230.67

17.90

40.17

43.91

4.60

233.33

17.50

36.62

44.55

6.80

240.00

17.10

47.98

70.76

4.00

233.33

16.80

45.50

52.75

3.30

240.00

17.30

40.56

57.05

4.60

225.33

20.50

40.51

43.25

5.80

236.33

15.60

44.80

46.00

3.50

227.00

15.50

29.86

49.57

4.00

230.00

11.40

29.11

32.94

7.40

227.67

17.60

44.33

40.30

6.20

241.67

14.80

43.93

64.54

3.50

236.33

17.90

35.53

44.00

5.80

226.33

19.60

42.81

50.68

4.80

243.67

17.30

49.56

61.05

3.10

230.00

17.00

40.65

48.04

5.90

233.67

19.30

36.64

53.30

3.90

216.33

27.00

46.48

34.38

9.00

233.00

18.70

40.56

38.41

5.10

235.00

17.10

47.58

51.92

4.10

217.33

19.10

46.21

38.54

10.60

242.00

15.80

45.06

61.80

3.70

235.00

13.50

47.44

60.32

4.30

228.00

13.90

50.45

39.99

5.70

233.33

16.90

45.79

62.47

3.20

225.33

17.60

42.41

41.99

5.30

232.67

12.00

44.65

36.96

2.50

237.00

17.20

46.96

59.37

4.10

220.33

21.00

41.12

29.04

13.40

220.67

17.10

37.38

35.56

7.20

227.00

18.50

38.80

40.14

5.90

244.67

15.70

43.07

74.31

3.30

231.33

16.90

45.35

51.51

4.20

230.33

17.60

34.88

39.76

4.50

230.33

16.60

42.07

52.55

4.60

227.33

16.10

36.97

43.40

4.30

230.00

17.60

44.83

48.51

4.70

241.67

18.00

48.01

68.58

4.60

231.00

19.30

46.54

47.46

5.20

226.00

15.80

37.74

39.83

5.20

235.67

17.90

40.58

47.45

3.80

232.33

19.40

46.56

56.79

4.00

223.33

17.80

40.03

37.40

6.60

222.67

16.60

38.98

36.51

4.50

219.00

16.70

39.13

28.97

9.10

227.33

18.50

44.45

40.66

6.70

221.67

19.20

37.15

33.36

8.90

232.67

17.30

43.53

52.51

5.20

232.00

14.90

35.08

53.27

5.20

233.67

14.00

41.00

54.63

4.40

227.33

19.80

36.14

35.43

7.50

234.00

17.00

38.33

50.93

3.40

228.33

17.30

37.22

39.83

5.60

240.33

15.10

42.72

47.40

4.40

228.33

15.70

34.34

35.36

8.80

238.67

16.50

32.65

44.82

2.60

239.33

16.70

46.58

59.47

2.90

243.00

16.70

41.87

47.48

3.60

240.00

15.60

42.91

35.04

4.40

239.33

14.20

31.91

46.82

3.20

225.00

21.40

40.52

43.21

7.30

241.33

16.90

50.97

66.39

3.70

226.00

21.30

43.92

43.95

4.40

238.33

17.80

37.38

62.71

3.90

217.00

16.40

38.39

29.37

15.90

231.67

17.90

43.45

51.12

4.50

239.67

17.40

41.10

62.26

3.40

231.00

17.40

43.10

51.70

4.10

226.67

16.30

45.65

42.73

6.50

234.33

16.70

43.39

52.28

4.70

215.33

21.40

44.25

26.40

17.40

236.33

13.30

40.16

42.36

5.40

230.67

18.40

39.51

46.70

4.30

246.33

14.50

41.95

44.23

3.60

223.00

20.80

38.35

41.93

5.40

245.00

15.40

55.10

76.41

3.10

235.67

16.00

41.38

55.31

3.70

238.67

15.20

43.91

70.13

2.80

221.33

21.50

41.72

35.14

10.60

225.00

18.00

40.31

40.91

3.80

231.67

19.10

44.07

49.63

3.30

220.00

20.50

42.93

35.83

10.20

237.33

16.30

48.42

64.20

2.40

226.67

18.40

46.75

42.10

5.60

237.00

14.50

40.04

66.02

4.00

234.00

17.50

38.51

53.78

5.30

242.33

16.00

38.87

65.02

3.30

232.33

17.90

48.76

47.31

5.10

232.00

16.80

41.62

55.52

5.30

225.33

18.20

39.76

34.59

7.20

231.33

17.20

41.27

50.87

5.10

247.00

16.60

46.79

73.52

2.90

222.00

16.30

43.53

45.53

4.00

240.00

17.40

41.94

59.86

4.80

232.33

17.30

45.00

53.87

3.70

224.33

21.50

39.18

44.90

5.80

227.67

21.60

42.67

41.42

8.20

231.67

13.10

41.22

45.28

6.50

235.67

19.60

46.55

45.13

4.50

230.67

19.00

45.55

54.77

4.10

238.00

18.80

41.04

61.96

3.20

233.33

18.30

39.98

39.60

4.50

232.33

8.90

37.00

49.21

3.80

239.33

17.00

45.95

56.00

3.50

244.67

17.00

51.81

69.52

3.30

220.00

20.90

41.86

28.37

10.70

243.00

17.00

48.47

70.07

3.30

230.00

13.40

38.32

30.89

8.50

231.67

15.00

31.40

39.91

5.80

236.33

19.90

44.27

61.47

4.40

228.00

18.90

39.73

48.66

5.40

232.00

19.10

40.12

41.97

6.70

234.67

14.50

36.48

37.56

6.90

238.00

18.10

42.94

57.13

3.70

241.00

19.70

42.76

47.35

6.60

244.33

16.80

53.85

65.40

2.80

232.00

17.20

44.29

50.39

4.20

228.67

19.70

44.09

40.90

6.30

229.33

18.00

36.40

36.32

6.40

225.67

19.00

41.50

44.95

4.60

228.67

18.00

40.62

40.07

7.30

229.67

18.70

44.64

43.60

6.90

230.67

10.00

31.81

29.39

4.40

227.67

18.80

44.93

44.18

4.50

223.33

19.50

41.69

50.72

3.60

242.33

17.00

46.84

60.92

3.20

222.00

19.80

45.21

37.21

6.30

228.33

21.00

45.13

44.47

6.80

235.67

16.40

36.99

48.17

3.90

226.33

18.10

40.33

40.78

6.60

237.33

19.10

44.34

48.15

4.60

225.00

15.70

42.62

48.67

4.10

238.67

17.80

44.99

59.17

3.90

226.33

18.10

43.90

50.10

3.60

243.67

15.20

39.00

66.42

3.10

242.33

13.90

41.87

53.21

3.00

222.67

9.60

44.75

42.88

3.10

222.33

19.30

40.77

38.53

5.10

226.33

15.10

36.68

34.31

9.40

233.00

16.40

41.32

45.96

4.10

213.67

16.90

37.96

30.82

13.70

240.33

20.00

46.23

51.27

3.40

231.00

16.90

40.52

47.49

4.20

228.33

19.50

41.22

49.21

3.80

228.67

15.70

42.49

60.18

3.70

231.67

16.70

40.87

43.16

3.10

219.33

20.80

43.64

38.53

7.60

230.67

19.30

46.12

56.79

3.50

234.33

20.00

38.77

52.36

4.80

227.00

19.90

40.94

45.55

4.00

234.67

16.90

42.48

51.82

3.80

234.67

18.10

41.86

57.19

3.70

229.33

14.60

41.62

45.73

4.40

226.67

17.00

39.30

35.38

6.50

225.00

17.90

40.84

34.91

7.00

231.33

15.90

48.09

49.47

3.10

248.00

18.20

53.43

79.78

3.20

228.33

15.10

42.04

37.14

7.60

243.67

15.30

49.35

90.03

3.40

243.00

16.40

47.63

54.57

3.20

238.00

15.10

32.58

48.59

3.50

230.00

13.20

42.08

47.86

3.40

225.33

19.50

38.94

40.14

6.80

236.67

19.10

47.55

63.05

3.30

242.67

15.60

54.44

108.75

2.50

225.67

19.20

41.89

42.25

3.30

225.00

21.90

36.10

39.91

6.20

247.33

13.30

45.62

67.32

2.00

228.33

18.20

43.05

48.33

4.40

229.67

17.60

47.46

55.19

3.00

226.67

15.50

35.95

35.83

6.10

242.67

16.90

53.97

74.89

3.10

226.33

16.60

38.65

45.68

3.90

233.33

18.40

45.49

50.43

4.80

223.67

16.60

42.84

36.26

9.30

244.33

17.60

41.01

69.04

4.60

230.67

15.60

37.70

34.71

5.40

242.67

14.80

41.86

41.14

7.20

232.67

16.80

34.70

48.84

3.80

228.00

15.30

37.20

33.60

7.10

230.00

14.50

43.56

41.08

5.80

237.67

13.20

42.59

55.02

3.10

227.33

19.20

42.27

43.29

4.60

235.00

21.30

52.41

50.05

4.70

235.00

17.30

44.71

42.08

5.00

242.33

14.80

54.21

82.32

2.80

234.33

17.70

42.64

33.38

6.00

233.00

18.00

38.51

46.35

3.70

243.33

11.50

53.71

103.60

2.80

233.67

19.00

42.06

42.79

5.00

238.33

14.00

42.52

39.07

4.80

230.33

17.10

40.76

50.73

3.80

233.00

15.30

37.72

40.12

4.00

224.00

16.20

37.23

40.07

4.80

240.33

18.30

39.44

61.31

3.40

231.67

15.90

35.01

36.34

7.20

239.67

16.90

36.92

55.56

3.30

235.67

16.60

41.10

54.39

3.20

236.33

18.00

38.29

44.80

4.60

233.33

15.30

47.39

56.57

3.30

240.00

12.70

51.30

76.55

3.60

232.00

13.60

44.45

40.43

5.20

241.00

16.40

45.23

70.43

2.90

237.33

21.10

36.37

56.43

2.80

235.67

15.70

49.91

42.42

4.30

235.33

14.10

37.42

36.28

5.90

224.33

15.10

34.93

38.45

3.60

241.00

15.80

43.47

60.05

3.40

245.00

14.20

48.20

65.34

3.40

234.00

18.60

40.66

49.81

5.40

235.33

15.50

39.68

48.33

3.80

239.00

16.70

34.42

52.16

3.60

231.67

15.30

30.23

37.79

5.20

230.67

16.90

37.13

42.31

3.90

227.67

14.30

40.83

31.94

8.60

233.00

16.20

45.23

47.52

4.60

231.67

16.30

45.67

35.67

3.60

226.00

14.50

38.78

44.83

5.30

231.00

18.30

42.53

41.36

5.40

231.67

15.20

49.06

42.29

4.50

229.00

17.30

42.38

45.91

3.90

237.33

17.70

43.51

53.90

3.50

228.00

16.60

37.67

37.64

5.90

230.67

19.20

44.79

47.64

5.10

a.) Estimate the sample regression equation. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

b.) What is the predicted score if STR = 18, TSAL = 50, INC = 60, and SGL = 5? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

c.) What is the predicted score if everything else is the same as above except INC = 80? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)

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_2

Step: 3

blur-text-image_3

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

Elementary Linear Algebra with Applications

Authors: Bernard Kolman, David Hill

9th edition

132296543, 978-0132296540

More Books

Students also viewed these Mathematics questions