Rearrange data to analyze Regression

profilePatrobabj
stats115question1-21142017.xlsx
Home>Mathematics homework help>Statistics homework help>Rearrange data to analyze Regression

Hospital charges

ID Sex Sex1 Age LOS DRG Charges Medicare Diag ICD-9 Use the data on the cost worksheet of chp9-1 that show the hospital cost for a randomly selected sample of 34 women and 34 men.
1 F 1 46 4 294 $ 2,426.48 $ 2,003.62 2 0 a. Rearrange the data so that they can be analyzed using regression and add an independent variable that is 1 for women and 0 for men
2 F 1 87 8 139 $ 6,815.61 $ 1,072.17 4 4 b. Test the hypothesis that the cost for women is equal to the cost for men (against the alternative that they are not equal) using regression
3 F 1 70 10 34 $ 7,596.68 $ 4,096.98 6 0
4 M 0 72 5 140 $ 6,450.77 $ 1,710.79 5 0
5 F 1 82 3 141 $ 3,542.79 $ 1,914.90 3 7
6 F 1 85 2 15 $ 2,590.86 $ 2,601.14 5 4
7 F 1 73 5 294 $ 5,082.83 $ 2,035.31 7 2
8 M 0 65 6 241 $ 3,580.55 $ 2,320.42 6 0
9 M 0 73 6 335 $ 11,045.79 $ 4,184.26 1 0
10 F 1 94 14 148 $ 19,708.11 $ 12,158.49 4 0
11 F 1 94 11 89 $ 8,953.38 $ 4,345.84 4 0
12 M 0 79 5 127 $ 7,000.21 $ 3,993.48 5 0
13 M 0 82 6 89 $ 5,330.24 $ 3,408.07 4 0
14 F 1 76 3 122 $ 6,864.63 $ 3,637.35 5 4
15 M 0 72 3 336 $ 4,318.13 $ 2,676.01 2 0
16 F 1 91 7 321 $ 6,424.30 $ 1,510.20 3 0
17 F 1 90 6 174 $ 5,184.53 $ 3,642.44 6 5
18 F 1 83 3 143 $ 1,871.78 $ 1,167.65 6 0
19 F 1 82 11 358 $ 11,179.97 $ 3,432.13 9 6
20 F 1 49 2 140 $ 3,405.38 $ 1,710.79 1 0
21 F 1 88 2 143 $ 1,731.73 $ 1,979.28 4 7
22 F 1 75 2 159 $ 5,384.92 $ 3,316.59 2 0
23 M 0 81 7 89 $ 5,216.91 $ 3,613.06 2 4
24 F 1 76 4 294 $ 2,489.65 $ 2,201.93 3 0
25 F 1 85 10 473 $ 8,244.25 $ 12,772.75 4 0
26 F 1 84 6 128 $ 3,548.05 $ 2,163.29 8 4
27 F 1 77 3 15 $ 4,713.26 $ 1,801.73 4 0
28 F 1 94 6 121 $ 5,804.21 $ 5,282.36 5 7
29 F 1 66 6 128 $ 2,945.22 $ 2,849.72 2 0
30 M 0 72 1 140 $ 1,035.75 $ 1,685.62 5 4
31 M 0 78 3 209 $ 17,005.45 $ 7,534.44 1 7
32 F 1 86 3 143 $ 4,637.96 $ 1,447.84 5 0
33 F 1 70 5 209 $ 17,480.97 $ 7,566.98 5 0
34 M 0 72 5 96 $ 5,029.09 $ 3,306.80 8 4
35 M 0 91 3 144 $ 3,078.99 $ 3,351.64 5 4
36 M 0 75 2 90 $ 2,146.99 $ 1,968.05 2 4
37 F 1 83 6 88 $ 5,482.93 $ 3,147.39 2 0
38 M 0 82 1 183 $ 1,078.56 $ 1,386.42 6 5
39 F 1 82 10 430 $ 9,931.21 $ 3,530.00 1 0
40 F 1 92 2 138 $ 2,451.69 $ 2,266.56 2 4
41 F 1 79 2 88 $ 2,834.68 $ 3,579.24 1 0
42 F 1 69 2 447 $ 1,547.81 $ 988.00 3 0
43 F 1 76 3 183 $ 1,876.70 $ 1,235.80 1 0
44 M 0 73 2 140 $ 2,781.28 $ 1,483.79 4 0
45 F 1 83 6 127 $ 6,460.59 $ 3,993.48 5 0
46 F 1 80 4 444 $ 3,026.42 $ 1,918.32 1 6
47 F 1 76 10 493 $ 14,769.92 $ 5,594.68 4 5
48 F 1 77 7 324 $ 4,425.44 $ 1,531.55 5 5
49 F 1 85 4 140 $ 5,151.52 $ 1,710.79 5 0
50 F 1 70 1 140 $ 2,404.39 $ 735.58 1 4
51 M 0 81 2 140 $ 5,019.86 $ 1,730.79 2 0
52 F 1 83 9 138 $ 10,421.01 $ 2,384.12 5 0
53 M 0 76 2 269 $ 4,860.83 $ 5,688.67 4 1
54 F 1 88 3 140 $ 2,694.11 $ 1,564.50 2 0
55 M 0 88 4 208 $ 2,421.63 $ 1,346.94 2 0
56 F 1 89 2 15 $ 3,311.66 $ 2,065.49 3 0
57 M 0 39 1 434 $ 1,596.91 $ 392.00 5 3
58 F 1 89 5 88 $ 5,399.67 $ 3,048.91 4 4
59 M 0 80 12 78 $ 17,605.59 $ 4,432.93 9 7
60 F 1 71 7 89 $ 11,098.70 $ 4,256.70 3 4
61 F 1 90 4 89 $ 3,674.03 $ 3,609.84 3 0
62 M 0 91 4 316 $ 3,720.09 $ 4,269.96 6 2
63 F 1 73 1 140 $ 2,472.64 $ 2,356.05 4 0
64 F 1 77 7 166 $ 7,792.24 $ 4,538.13 1 5
65 F 1 78 2 175 $ 3,489.88 $ 1,430.32 3 5
66 F 1 79 4 203 $ 4,655.83 $ 3,965.21 9 6
67 F 1 85 14 87 $ 10,242.50 $ 4,531.65 6 0
68 F 1 74 1 296 $ 1,599.82 $ 2,628.95 3 0
69 M 0 78 10 294 $ 6,015.34 $ 2,003.62 5 0
70 F 1 92 2 127 $ 1,905.65 $ 3,993.48 5 0
71 M 0 56 1 294 $ 707.70 $ 2,102.01 3 2
72 M 0 76 2 183 $ 3,004.67 $ 1,423.87 4 5
73 F 1 84 10 197 $ 18,290.04 $ 6,862.34 5 0
74 F 1 75 3 132 $ 5,621.92 $ 1,772.78 5 7
75 F 1 68 7 240 $ 5,547.71 $ 4,565.48 5 7
76 M 0 50 2 182 $ 2,581.72 $ 2,238.61 3 5
77 M 0 49 9 436 $ 7,024.64 $ 2,441.00 5 0
78 M 0 76 3 175 $ 4,242.10 $ 1,344.35 4 5
79 M 0 76 3 207 $ 4,286.90 $ 3,045.51 2 5
80 F 1 67 2 359 $ 12,313.78 $ 2,393.04 3 0
81 M 0 96 11 79 $ 8,217.27 $ 5,462.63 4 0
82 F 1 83 16 127 $ 10,655.80 $ 3,277.48 5 0
83 F 1 77 3 182 $ 3,620.78 $ 2,064.43 5 5
84 M 0 86 5 346 $ 4,734.98 $ 3,731.44 2 0
85 F 1 80 1 140 $ 1,820.41 $ 1,564.50 2 0
86 F 1 61 8 296 $ 8,954.81 $ 3,351.61 4 2
87 M 0 80 5 236 $ 4,177.90 $ 2,314.57 6 0
88 F 1 78 2 122 $ 5,756.89 $ 2,156.63 3 4
89 F 1 71 10 90 $ 12,919.48 $ 2,711.94 3 0
90 M 0 90 9 89 $ 7,022.47 $ 2,589.84 2 0
91 F 1 91 7 296 $ 6,823.60 $ 3,516.57 6 4
92 F 1 69 4 248 $ 2,384.47 $ 2,084.09 5 0
93 M 0 88 5 278 $ 3,169.19 $ 2,131.82 4 0
94 F 1 76 2 143 $ 2,721.63 $ 1,150.43 6 7
95 F 1 83 5 321 $ 3,034.14 $ 1,630.16 7 0
96 F 1 75 3 127 $ 5,041.93 $ 3,645.46 1 4
97 M 0 83 7 140 $ 8,118.92 $ 1,730.79 5 0
98 M 0 68 9 79 $ 10,955.29 $ 5,662.61 8 4
99 M 0 75 7 101 $ 5,363.25 $ 3,409.08 5 5
100 M 0 60 5 14 $ 6,572.60 $ 3,892.79 6 4

SWC

Country U5MR IMR LEB
1 Afghanistan 257 165 46
2 Albania 35 29 73
3 Algeria 41 36 69
4 Angola 295 172 48
5 Argentina 22 19 73
6 Armenia 30 25 71
7 Australia 5 5 78
8 Austria 5 4 77
9 Azerbaijan 45 35 70
10 Bangladesh 89 58 59
11 Belarus 28 23 68
12 Belgium 6 6 77
13 Benin 156 99 54
14 Bhutan 107 80 62
15 Bolivia 83 64 62
16 Bosnia and Herzegovina 18 15 74
17 Botswana 59 46 45
18 Brazil 40 34 67
19 Bulgaria 17 14 72
20 Burkina Faso 199 106 45
21 Burundi 176 106 43
22 Cambodia 122 86 54
23 Cameroon 154 95 54
24 Canada 6 6 79
25 Central African Rep. 172 113 45
26 Chad 198 118 48
27 Chile 12 11 75
28 China 41 33 70
29 Colombia 31 26 71
30 Congo 108 81 49
31 Congo, Dem. Rep. 207 128 52
32 Costa Rica 14 13 76
33 Côte d'Ivoire 171 102 47
34 Croatia 9 8 73
35 Cuba 8 6 76
36 Czech Rep. 5 5 74
37 Denmark 5 4 76
38 Dominican Rep. 49 43 71
39 Ecuador 35 27 70
40 Egypt 52 41 67
41 El Salvador 42 35 70
42 Eritrea 105 66 51
43 Estonia 21 17 69
44 Ethiopia 176 118 44
45 Finland 5 4 77
46 France 5 5 78
47 Gabon 143 85 52
48 Gambia 75 61 48
49 Georgia 23 19 73
50 Germany 5 5 77
51 Ghana 101 63 61
52 Greece 7 6 78
53 Guatemala 60 45 65
54 Guinea 181 115 47
55 Guinea-Bissau 200 128 45
56 Haiti 129 83 54
57 Honduras 42 33 70
58 Hungary 10 9 71
59 India 98 70 63
60 Indonesia 52 38 66
61 Iran 46 37 70
62 Iraq 128 104 65
63 Ireland 7 6 77
64 Israel 6 6 78
65 Italy 6 6 78
66 Jamaica 11 10 75
67 Japan 4 4 80
68 Jordan 35 29 71
69 Kazakhstan 42 35 68
70 Kenya 118 76 51
71 Korea, Dem. People's Rep. 30 23 73
72 Korea, Rep. of 5 5 73
73 Kuwait 12 11 76
74 Kyrgyzstan 65 55 68
75 Lao People's Dem. Rep. 111 93 54
76 Latvia 21 17 69
77 Lebanon 32 28 70
78 Lesotho 134 93 54
79 Liberia 235 157 50
80 Libya 22 19 70
81 Lithuania 22 18 71
82 Madagascar 156 95 58
83 Malawi 211 132 40
84 Malaysia 9 8 72
85 Mali 235 143 54
86 Mauritania 183 120 54
87 Mauritius 23 19 72
88 Mexico 33 27 73
89 Moldova, Rep. of 34 27 68
90 Mongolia 80 61 67
91 Morocco 53 45 67
92 Mozambique 203 127 42
93 Myanmar 112 79 61
94 Namibia 70 56 48
95 Nepal 104 75 58
96 Netherlands 5 5 78
97 New Zealand 6 6 77
98 Nicaragua 47 38 68
99 Niger 275 162 49
100 Nigeria 187 112 50
101 Norway 4 4 78
102 Oman 16 14 71
103 Pakistan 112 84 65
104 Panama 27 21 74
105 Papua New Guinea 112 79 59
106 Paraguay 32 27 70
107 Peru 52 42 69
108 Philippines 42 31 69
109 Poland 10 9 73
110 Portugal 6 5 76
111 Romania 24 21 70
112 Russian Federation 22 18 67
113 Rwanda 180 110 41
114 Saudi Arabia 25 20 72
115 Senegal 118 68 53
116 Sierra Leone 316 182 39
117 Singapore 4 4 78
118 Slovakia 10 9 73
119 Slovenia 6 5 75
120 Somalia 211 125 48
121 South Africa 69 54 52
122 Spain 6 6 78
123 Sri Lanka 19 17 74
124 Sudan 109 67 56
125 Sweden 4 3 79
126 Switzerland 4 3 79
127 Syria 30 25 69
128 Tajikistan 74 54 68
129 Tanzania 141 90 48
130 TFYR Macedonia 26 22 73
131 Thailand 30 26 69
132 Togo 143 80 49
133 Trinidad and Tobago 20 17 74
134 Tunisia 30 24 70
135 Turkey 48 40 70
136 Turkmenistan 71 52 66
137 Uganda 131 83 42
138 Ukraine 21 17 69
139 United Arab Emirates 9 8 75
140 United Kingdom 6 6 78
141 United States 8 7 77
142 Uruguay 17 15 74
143 Uzbekistan 58 45 68
144 Venezuela 23 20 73
145 Viet Nam 40 31 68
146 Yemen 119 86 59
147 Yugoslavia 23 20 73
148 Zambia 202 112 41
149 Zimbabwe 90 60 43

US IMR

State IMR 1998
Alabama 10.2
Alaska 5.9
Arizona 7.5
Arkansas 8.9
California 5.8
Colorado 6.7
Connecticut 7
Delaware 9.6
Florida 7.2
Georgia 8.5
Hawaii 6.9
Idaho 7.2
Illinois 8.4
Indiana 7.6
Iowa 6.6
Kansas 7
Kentucky 7.5
Louisiana 9.1
Maine 6.3
Maryland 8.6
Massachusetts 5.1
Michigan 8.2
Minnesota 5.9
Mississippi 10.1
Missouri 7.7
Montana 7.4
Nebraska 7.3
Nevada 7
New Hampshire 4.4
New Jersey 6.4
New Mexico 7.2
New York 6.3
North Carolina 9.3
North Dakota 8.6
Ohio 8
Oklahoma 8.5
Oregon 5.4
Pennsylvania 7.1
Rhode Island 7
South Carolina 9.6
South Dakota 9.1
Tennessee 8.2
Texas 6.4
Utah 5.6
Vermont 7
Virginia 7.7
Washington 5.7
West Virginia 8
Wisconsin 7.2
Wyoming 7.2