regression analysis project

profileAb99cd26fe
xlsx.xlsx
Home>Mathematics homework help>Statistics homework help>regression analysis project

Variables

Health
The data (X1, X2, X3, X4, X5) are by city.
X1 = death rate per 1000 residents
X2 = doctor availability per 100,000 residents
X3 = hospital availability per 100,000 residents
X4 = annual per capita income in thousands of dollars
X5 = population density people per square mile
Reference: Life In America's Small Cities, by G.S. Thomas

Crosstabulation

City Hospital Availability DOC AVAILABLILITY
1 284 78 Count of City Column Labels
2 433 68 Row Labels 190-456 457-723 724-990 1258-1524 1525-1792 Grand Total
3 739 70 60-89 11 5 1 17
4 1792 96 90-119 8 4 1 2 15
5 477 74 120-149 3 5 3 1 12
6 362 111 150-179 1 3 1 5
7 671 77 180-209 2 1 3
8 636 168 210-239 1 1
9 329 82 Grand Total 23 19 7 2 2 53
10 634 89
11 631 149
12 257 60
13 284 96
14 603 83
15 686 130
16 345 145
17 1357 112
18 544 131
19 205 80
20 1264 130
21 688 140
22 354 154
23 1632 118
24 348 94
25 370 119
26 648 153
27 366 116
28 540 97
29 680 176
30 345 75
31 525 134
32 870 161
33 669 111
34 452 114
35 430 142
36 822 238
37 190 78
38 867 196
39 969 125
40 499 82
41 925 125
42 353 129
43 288 84
44 718 183
45 540 119
46 668 180
47 347 82
48 345 71
49 463 118
50 728 121
51 383 68
52 316 112
53 388 109

Frequency

Row Labels Count of X2 R.F. % Cumulative Row Labels Count of X4 Relative: %: Cumulative:
60-89 17 0.32 32% 17 7.19-8.16 5 0.09 9% 5
90-119 15 0.28 28% 32 8.16-9.13 16 0.30 30% 21
120-149 12 0.23 23% 44 9.13-10.1 17 0.32 32% 38
150-179 5 0.09 9% 49 10.1-11.07 13 0.25 25% 51
180-209 3 0.06 6% 52 11.07-12.04 1 0.02 2% 52
210-239 1 0.02 2% 53 12.04-13.01 1 0.02 2% 53
Grand Total 53 Grand Total 53
Row Labels Count of X5 R.F % Cumulative
35-77 11 0.21 21% 11
78-120 25 0.47 47% 36
121-163 11 0.21 21% 47
164-206 5 0.09 9% 52
250-292 1 0.02 2% 53
Grand Total 53
Row Labels Count of X3 R.F. % Cumulative
190-456 23 0.43 43% 23
Row Labels Count of X1 R.F. % Cumulative: 457-723 19 0.36 36% 42
<4 1 0.02 2% 1 724-990 7 0.13 13% 49
4-6 1 0.02 2% 2 1258-1524 2 0.04 4% 51
6-8 6 0.11 11% 8 1525-1792 2 0.04 4% 53
8-10 26 0.49 49% 34 Grand Total 53
10-12 18 0.34 34% 52
12-14 1 0.02 2% 53
Grand Total 53 Total: 1.00 100%

X1 Death Rate

Total < 4 4-6 6-8 8-10 10-12 12-14 1 1 6 26 18 1

ScatterPlot

dependent (Y)=Hospital Availability
independent(X)=Doctor Availability
The relationship is positive. The trendline shows as doctor availabliity oes up so does hospital availability.

Hospital Availability/Doc Availability

Hospital Availa bility 78 68 70 96 74 111 77 168 82 89 149 60 96 83 130 145 112 131 80 130 140 154 118 94 119 153 116 97 176 75 134 161 111 114 142 238 78 196 125 82 125 129 84 183 119 180 82 71 118 121 68 112 109 284 433 739 1792 477 362 671 636 329 634 631 257 284 603 686 345 1357 544 205 1264 688 354 1632 348 370 648 366 540 680 345 525 870 669 452 430 822 190 867 969 499 925 353 288 718 540 668 347 345 463 728 383 316 388

Doctor

Hospital

Sheet2

DEATH RATE DOC AVAILABLILITY Hospital Availability Annual income Population Density X6
8.00 78 284 9.100000381 109 1
9.30 68 433 8.699999809 144 1
7.50 70 739 7.199999809 113 0
8.90 96 1792 8.899999619 97 1
10.20 74 477 8.300000191 206 0
8.30 111 362 10.89999962 124 1
8.80 77 671 10 152 0
8.80 168 636 9.100000381 162 1
10.70 82 329 8.699999809 150 0
11.70 89 634 7.599999905 134 1
8.50 149 631 10.80000019 292 0
8.30 60 257 9.5 108 0
8.20 96 284 8.800000191 111 1
7.90 83 603 9.5 182 0
10.30 130 686 8.699999809 129 0
7.40 145 345 11.19999981 158 0
9.60 112 1357 9.699999809 186 1
9.30 131 544 9.600000381 177 0
10.60 80 205 9.100000381 127 0
9.70 130 1264 9.199999809 179 1
11.60 140 688 8.300000191 80 0
8.10 154 354 8.399999619 103 0
9.80 118 1632 9.399999619 101 1
7.40 94 348 9.800000191 117 0
9.40 119 370 10.39999962 88 1
11.20 153 648 9.899999619 78 0
9.10 116 366 9.199999809 102 1
10.50 97 540 10.30000019 95 0
11.90 176 680 8.899999619 80 0
8.40 75 345 9.600000381 92 1
5.00 134 525 10.30000019 126 0
9.80 161 870 10.39999962 108 0
9.80 111 669 9.699999809 77 1
10.80 114 452 9.600000381 60 0
10.10 142 430 10.69999981 71 0
10.90 238 822 10.30000019 86 1
9.20 78 190 10.69999981 93 0
8.30 196 867 9.600000381 106 0
7.30 125 969 10.5 162 1
9.40 82 499 7.699999809 95 1
9.40 125 925 10.19999981 91 1
9.80 129 353 9.899999619 52 1
3.60 84 288 8.399999619 110 1
8.40 183 718 10.39999962 69 0
10.80 119 540 9.199999809 57 0
10.10 180 668 13 106 0
9.00 82 347 8.800000191 40 0
10.00 71 345 9.199999809 50 0
11.30 118 463 7.800000191 35 0
11.30 121 728 8.199999809 86 1
12.80 68 383 7.400000095 57 1
10.00 112 316 10.39999962 57 1
6.70 109 388 8.899999619 94 0