Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Sex Sex1 Age LOS DRG F 1 46 4 294 F 1 87 8 139 F 1 70 10 34 M 0 72 5 140 F 1 82 3 141 F 1 85 2 15 F 1 73 5 294 M 0 65 6 241 M 0 73 6 335 F 1 94 14 148 F 1 94 11 89 M 0 79 5 127 M 0 82 6 89 F 1 76 3 122 M 0 72 3 336 F 1 91 7 321 F 1 90 6 174 F 1 83 3 143 F 1 82 11 358 F 1 49 2 140 F 1 88 2 143 F 1 75 2 159 M 0 81 7 89 F 1 76 4 294 F 1 85 10 473 F 1 84 6 128 F 1 77 3 15 F 1 94 6 121 F 1 66 6 128 M 0 72 1 140 M 0 78 3 209 F 1 86 3 143 F 1 70 5 209 M 0 72 5 96 M 0 91 3 144 M 0 75 2 90 F 1 83 6 88 M 0 82 1 183 F 1 82 10 430 F 1 92 2 138 F 1 79 2 88 F 1 69 2 447 F 1 76 3 183 M 0 73 2 140 F 1 83 6 127 F 1 80 4 444 F 1 76 10 493 F 1 77 7 324 F 1 85 4 140 F 1 70 1 140 M 0 81 2 140 F 1 83 9 138 M 0 76 2 269 Charges Medicare Diag ICD-9 $ 2,426.48 $ 2,003.62 2 0 $ 6,815.61 $ 1,072.17 4 4 $ 7,596.68 $ 4,096.98 6 0 $ 6,450.77 $ 1,710.79 5 0 $ 3,542.79 $ 1,914.90 3 7 $ 2,590.86 $ 2,601.14 5 4 $ 5,082.83 $ 2,035.31 7 2 $ 3,580.55 $ 2,320.42 6 0 $11,045.79 $ 4,184.26 1 0 $19,708.11 $12,158.49 4 0 $ 8,953.38 $ 4,345.84 4 0 $ 7,000.21 $ 3,993.48 5 0 $ 5,330.24 $ 3,408.07 4 0 $ 6,864.63 $ 3,637.35 5 4 $ 4,318.13 $ 2,676.01 2 0 $ 6,424.30 $ 1,510.20 3 0 $ 5,184.53 $ 3,642.44 6 5 $ 1,871.78 $ 1,167.65 6 0 $11,179.97 $ 3,432.13 9 6 $ 3,405.38 $ 1,710.79 1 0 $ 1,731.73 $ 1,979.28 4 7 $ 5,384.92 $ 3,316.59 2 0 $ 5,216.91 $ 3,613.06 2 4 $ 2,489.65 $ 2,201.93 3 0 $ 8,244.25 $12,772.75 4 0 $ 3,548.05 $ 2,163.29 8 4 $ 4,713.26 $ 1,801.73 4 0 $ 5,804.21 $ 5,282.36 5 7 $ 2,945.22 $ 2,849.72 2 0 $ 1,035.75 $ 1,685.62 5 4 $17,005.45 $ 7,534.44 1 7 $ 4,637.96 $ 1,447.84 5 0 $17,480.97 $ 7,566.98 5 0 $ 5,029.09 $ 3,306.80 8 4 $ 3,078.99 $ 3,351.64 5 4 $ 2,146.99 $ 1,968.05 2 4 $ 5,482.93 $ 3,147.39 2 0 $ 1,078.56 $ 1,386.42 6 5 $ 9,931.21 $ 3,530.00 1 0 $ 2,451.69 $ 2,266.56 2 4 $ 2,834.68 $ 3,579.24 1 0 $ 1,547.81 $ 988.00 3 0 $ 1,876.70 $ 1,235.80 1 0 $ 2,781.28 $ 1,483.79 4 0 $ 6,460.59 $ 3,993.48 5 0 $ 3,026.42 $ 1,918.32 1 6 $14,769.92 $ 5,594.68 4 5 $ 4,425.44 $ 1,531.55 5 5 $ 5,151.52 $ 1,710.79 5 0 $ 2,404.39 $ 735.58 1 4 $ 5,019.86 $ 1,730.79 2 0 $10,421.01 $ 2,384.12 5 0 $ 4,860.83 $ 5,688.67 4 1 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 F M F M F M F F M F F F F F F M F M M F F F M M M M F M F F M F F M F F M F F M F F F M M M M 1 0 1 0 1 0 1 1 0 1 1 1 1 1 1 0 1 0 0 1 1 1 0 0 0 0 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 1 0 0 0 0 88 88 89 39 89 80 71 90 91 73 77 78 79 85 74 78 92 56 76 84 75 68 50 49 76 76 67 96 83 77 86 80 61 80 78 71 90 91 69 88 76 83 75 83 68 75 60 3 4 2 1 5 12 7 4 4 1 7 2 4 14 1 10 2 1 2 10 3 7 2 9 3 3 2 11 16 3 5 1 8 5 2 10 9 7 4 5 2 5 3 7 9 7 5 140 208 15 434 88 78 89 89 316 140 166 175 203 87 296 294 127 294 183 197 132 240 182 436 175 207 359 79 127 182 346 140 296 236 122 90 89 296 248 278 143 321 127 140 79 101 14 $ 2,694.11 $ 2,421.63 $ 3,311.66 $ 1,596.91 $ 5,399.67 $17,605.59 $11,098.70 $ 3,674.03 $ 3,720.09 $ 2,472.64 $ 7,792.24 $ 3,489.88 $ 4,655.83 $10,242.50 $ 1,599.82 $ 6,015.34 $ 1,905.65 $ 707.70 $ 3,004.67 $18,290.04 $ 5,621.92 $ 5,547.71 $ 2,581.72 $ 7,024.64 $ 4,242.10 $ 4,286.90 $12,313.78 $ 8,217.27 $10,655.80 $ 3,620.78 $ 4,734.98 $ 1,820.41 $ 8,954.81 $ 4,177.90 $ 5,756.89 $12,919.48 $ 7,022.47 $ 6,823.60 $ 2,384.47 $ 3,169.19 $ 2,721.63 $ 3,034.14 $ 5,041.93 $ 8,118.92 $10,955.29 $ 5,363.25 $ 6,572.60 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,564.50 1,346.94 2,065.49 392.00 3,048.91 4,432.93 4,256.70 3,609.84 4,269.96 2,356.05 4,538.13 1,430.32 3,965.21 4,531.65 2,628.95 2,003.62 3,993.48 2,102.01 1,423.87 6,862.34 1,772.78 4,565.48 2,238.61 2,441.00 1,344.35 3,045.51 2,393.04 5,462.63 3,277.48 2,064.43 3,731.44 1,564.50 3,351.61 2,314.57 2,156.63 2,711.94 2,589.84 3,516.57 2,084.09 2,131.82 1,150.43 1,630.16 3,645.46 1,730.79 5,662.61 3,409.08 3,892.79 2 2 3 5 4 9 3 3 6 4 1 3 9 6 3 5 5 3 4 5 5 5 3 5 4 2 3 4 5 5 2 2 4 6 3 3 2 6 5 4 6 7 1 5 8 5 6 0 0 0 3 4 7 4 0 2 0 5 5 6 0 0 0 0 2 5 0 7 7 5 0 5 5 0 0 0 5 0 0 2 0 4 0 0 4 0 0 7 0 4 0 4 5 4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Country Afghanistan Albania Algeria Angola Argentina Armenia Australia Austria Azerbaijan Bangladesh Belarus Belgium Benin Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Central African Rep. Chad Chile China Colombia Congo Congo, Dem. Rep. Costa Rica Cte d'Ivoire Croatia Cuba Czech Rep. Denmark Dominican Rep. Ecuador Egypt El Salvador Eritrea Estonia Ethiopia Finland France Gabon Gambia Georgia Germany Ghana Greece Guatemala U5MR IMR 257 35 41 295 22 30 5 5 45 89 28 6 156 107 83 18 59 40 17 199 176 122 154 6 172 198 12 41 31 108 207 14 171 9 8 5 5 49 35 52 42 105 21 176 5 5 143 75 23 5 101 7 60 LEB 165 29 36 172 19 25 5 4 35 58 23 6 99 80 64 15 46 34 14 106 106 86 95 6 113 118 11 33 26 81 128 13 102 8 6 5 4 43 27 41 35 66 17 118 4 5 85 61 19 5 63 6 45 46 73 69 48 73 71 78 77 70 59 68 77 54 62 62 74 45 67 72 45 43 54 54 79 45 48 75 70 71 49 52 76 47 73 76 74 76 71 70 67 70 51 69 44 77 78 52 48 73 77 61 78 65 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 Guinea Guinea-Bissau Haiti Honduras Hungary India Indonesia Iran Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Korea, Dem. People's Rep. Korea, Rep. of Kuwait Kyrgyzstan Lao People's Dem. Rep. Latvia Lebanon Lesotho Liberia Libya Lithuania Madagascar Malawi Malaysia Mali Mauritania Mauritius Mexico Moldova, Rep. of Mongolia Morocco Mozambique Myanmar Namibia Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru 181 200 129 42 10 98 52 46 128 7 6 6 11 4 35 42 118 30 5 12 65 111 21 32 134 235 22 22 156 211 9 235 183 23 33 34 80 53 203 112 70 104 5 6 47 275 187 4 16 112 27 112 32 52 115 128 83 33 9 70 38 37 104 6 6 6 10 4 29 35 76 23 5 11 55 93 17 28 93 157 19 18 95 132 8 143 120 19 27 27 61 45 127 79 56 75 5 6 38 162 112 4 14 84 21 79 27 42 47 45 54 70 71 63 66 70 65 77 78 78 75 80 71 68 51 73 73 76 68 54 69 70 54 50 70 71 58 40 72 54 54 72 73 68 67 67 42 61 48 58 78 77 68 49 50 78 71 65 74 59 70 69 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 Philippines Poland Portugal Romania Russian Federation Rwanda Saudi Arabia Senegal Sierra Leone Singapore Slovakia Slovenia Somalia South Africa Spain Sri Lanka Sudan Sweden Switzerland Syria Tajikistan Tanzania TFYR Macedonia Thailand Togo Trinidad and Tobago Tunisia Turkey Turkmenistan Uganda Ukraine United Arab Emirates United Kingdom United States Uruguay Uzbekistan Venezuela Viet Nam Yemen Yugoslavia Zambia Zimbabwe 42 10 6 24 22 180 25 118 316 4 10 6 211 69 6 19 109 4 4 30 74 141 26 30 143 20 30 48 71 131 21 9 6 8 17 58 23 40 119 23 202 90 31 9 5 21 18 110 20 68 182 4 9 5 125 54 6 17 67 3 3 25 54 90 22 26 80 17 24 40 52 83 17 8 6 7 15 45 20 31 86 20 112 60 69 73 76 70 67 41 72 53 39 78 73 75 48 52 78 74 56 79 79 69 68 48 73 69 49 74 70 70 66 42 69 75 78 77 74 68 73 68 59 73 41 43 State IMR 1998 Alabama 10.2 Alaska 5.9 Arizona 7.5 Arkansas 8.9 California 5.8 Colorado 6.7 Connecticu 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 Massachus 5.1 Michigan 8.2 Minnesota 5.9 Mississippi 10.1 Missouri 7.7 Montana 7.4 Nebraska 7.3 Nevada 7 New Hamps 4.4 New Jerse 6.4 New Mexic 7.2 New York 6.3 North Carol 9.3 North Dako 8.6 Ohio 8 Oklahoma 8.5 Oregon 5.4 Pennsylvan 7.1 Rhode Isla 7 South Caro 9.6 South Dako 9.1 Tennessee 8.2 Texas 6.4 Utah 5.6 Vermont 7 Virginia 7.7 Washingto 5.7 West Virgin 8 Wisconsin 7.2 Wyoming 7.2 Male Violence No Violence 1130 2275 3405 Female 1239 2849 4088 2369 5124 7493 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Country Afghanistan Albania Algeria Angola Argentina Armenia Australia Austria Azerbaijan Bangladesh Belarus Belgium Benin Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Central African Rep. Chad Chile China Colombia Congo Congo, Dem. Rep. Costa Rica C??te d'Ivoire Croatia Cuba Czech Rep. Denmark Dominican Rep. Ecuador Egypt El Salvador Eritrea Estonia Ethiopia Finland France Gabon Gambia Georgia Germany Ghana Greece Guatemala U5MR Africa 257 35 41 295 22 30 5 5 45 89 28 6 156 107 83 18 59 40 17 199 176 122 154 6 172 198 12 41 31 108 207 14 171 9 8 5 5 49 35 52 42 105 21 176 5 5 143 75 23 5 101 7 60 Child Friendly 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 1 0 1 0 1 1 0 0 0 1 1 0 1 0 0 0 0 0 0 1 0 1 0 1 0 0 1 1 0 0 1 0 0 0 1 1 0 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 0 0 0 0 1 0 0 1 1 1 0 0 1 0 1 1 1 1 1 1 1 1 0 1 0 1 1 0 1 1 1 0 1 1 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 Guinea Guinea-Bissau Haiti Honduras Hungary India Indonesia Iran Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Korea, Dem. People's Rep. Korea, Rep. of Kuwait Kyrgyzstan Lao People's Dem. Rep. Latvia Lebanon Lesotho Liberia Libya Lithuania Madagascar Malawi Malaysia Mali Mauritania Mauritius Mexico Moldova, Rep. of Mongolia Morocco Mozambique Myanmar Namibia Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru 181 200 129 42 10 98 52 46 128 7 6 6 11 4 35 42 118 30 5 12 65 111 21 32 134 235 22 22 156 211 9 235 183 23 33 34 80 53 203 112 70 104 5 6 47 275 187 4 16 112 27 112 32 52 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 1 0 1 1 0 1 1 0 0 0 0 1 1 0 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 0 1 1 0 0 1 1 0 0 1 0 0 1 1 1 1 1 0 0 1 0 1 1 1 0 0 1 1 0 1 0 1 1 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 Philippines Poland Portugal Romania Russian Federation Rwanda Saudi Arabia Senegal Sierra Leone Singapore Slovakia Slovenia Somalia South Africa Spain Sri Lanka Sudan Sweden Switzerland Syria Tajikistan Tanzania TFYR Macedonia Thailand Togo Trinidad and Tobago Tunisia Turkey Turkmenistan Uganda Ukraine United Arab Emirates United Kingdom United States Uruguay Uzbekistan Venezuela Viet Nam Yemen Yugoslavia Zambia Zimbabwe 42 10 6 24 22 180 25 118 316 4 10 6 211 69 6 19 109 4 4 30 74 141 26 30 143 20 30 48 71 131 21 9 6 8 17 58 23 40 119 23 202 90 0 0 0 0 0 1 0 1 1 0 0 0 1 1 0 0 1 0 0 0 0 1 0 0 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 0 1 0 0 1 1 1 0 1 1 1 0 1 1 1 1 0 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 0 1 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Sex LOS Stay F 4 Long F 8 Long F 10 Long M 5 Long F 3 Short F 2 Short F 5 Long M 6 Long M 6 Long F 14 Long F 11 Long M 5 Long M 6 Long F 3 Short M 3 Short F 7 Long F 6 Long F 3 Short F 11 Long F 2 Short F 2 Short F 2 Short M 7 Long F 4 Long F 10 Long F 6 Long F 3 Short F 6 Long F 6 Long M 1 Short M 3 Short F 3 Short F 5 Long M 5 Long M 3 Short M 2 Short F 6 Long M 1 Short F 10 Long F 2 Short F 2 Short F 2 Short F 3 Short M 2 Short F 6 Long F 4 Long F 10 Long F 7 Long F 4 Long F 1 Short M 2 Short F 9 Long M 2 Short 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 F M F M F M F F M F F F F F F M F M M F F F M M M M F M F F M F F M F F M F F M F F F M M M M 3 4 2 1 5 12 7 4 4 1 7 2 4 14 1 10 2 1 2 10 3 7 2 9 3 3 2 11 16 3 5 1 8 5 2 10 9 7 4 5 2 5 3 7 9 7 5 Short Long Short Short Long Long Long Long Long Short Long Short Long Long Short Long Short Short Short Long Short Long Short Long Short Short Short Long Long Short Long Short Long Long Short Long Long Long Long Long Short Long Short Long Long Long Long Male Psychological Physical No Violence 208 422 2275 2905 Female 1239 497 2849 4585 1447 919 5124 7490 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Sex DRG DRG Categ M 269 D. Other M 436 D. Other M 14 C. Other Internal F 294 C. Other Internal F 140 A. Heart and Circulatory F 143 A. Heart and Circulatory F 132 A. Heart and Circulatory F 121 A. Heart and Circulatory F 90 B. Respiratory F 122 A. Heart and Circulatory M 90 B. Respiratory F 447 D. Other M 316 C. Other Internal F 121 A. Heart and Circulatory F 140 A. Heart and Circulatory M 90 B. Respiratory F 127 A. Heart and Circulatory F 324 C. Other Internal F 248 D. Other M 294 C. Other Internal M 127 A. Heart and Circulatory F 209 D. Other F 140 A. Heart and Circulatory M 140 A. Heart and Circulatory F 140 A. Heart and Circulatory F 121 A. Heart and Circulatory F 87 B. Respiratory F 127 A. Heart and Circulatory M 89 B. Respiratory F 203 C. Other Internal M 89 B. Respiratory M 175 C. Other Internal F 89 B. Respiratory M 89 B. Respiratory F 143 A. Heart and Circulatory M 140 A. Heart and Circulatory F 128 A. Heart and Circulatory F 138 A. Heart and Circulatory M 79 B. Respiratory M 14 C. Other Internal F 294 C. Other Internal F 127 A. Heart and Circulatory F 138 A. Heart and Circulatory F 444 D. Other F 182 C. Other Internal F 358 C. Other Internal M 140 A. Heart and Circulatory F 174 C. Other Internal F 444 D. Other F 139 A. Heart and Circulatory M 335 C. Other Internal F 128 A. Heart and Circulatory M 207 C. Other Internal 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 F F M F M M F M M F M F F F F F M F F M M F M F F M M M F F M M M F F M M F F F F F F M M M F F F F F F M F 294 197 96 15 183 101 447 140 183 15 208 183 140 139 127 138 269 174 132 140 101 197 140 175 447 294 182 140 493 127 278 436 144 140 296 140 79 140 359 174 359 358 182 101 78 236 138 88 141 296 296 359 208 15 C. Other Internal C. Other Internal B. Respiratory C. Other Internal C. Other Internal B. Respiratory D. Other A. Heart and Circulatory C. Other Internal C. Other Internal C. Other Internal C. Other Internal A. Heart and Circulatory A. Heart and Circulatory A. Heart and Circulatory A. Heart and Circulatory D. Other C. Other Internal A. Heart and Circulatory A. Heart and Circulatory B. Respiratory C. Other Internal A. Heart and Circulatory C. Other Internal D. Other C. Other Internal C. Other Internal A. Heart and Circulatory C. Other Internal A. Heart and Circulatory D. Other D. Other A. Heart and Circulatory A. Heart and Circulatory C. Other Internal A. Heart and Circulatory B. Respiratory A. Heart and Circulatory C. Other Internal C. Other Internal C. Other Internal C. Other Internal C. Other Internal B. Respiratory B. Respiratory D. Other A. Heart and Circulatory B. Respiratory A. Heart and Circulatory C. Other Internal C. Other Internal C. Other Internal C. Other Internal C. Other Internal 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 M F F F F F F M F F F M M F F M F M F M F M F F F M M M F M F F F F M F F M F M M F F F F F F M F F F M F M 208 89 140 140 294 296 88 79 324 248 296 346 175 127 128 434 34 183 296 79 430 182 294 166 148 241 434 346 140 236 34 143 159 15 294 148 203 140 240 209 294 89 128 34 89 88 143 436 183 166 143 336 294 434 C. Other Internal B. Respiratory A. Heart and Circulatory A. Heart and Circulatory C. Other Internal C. Other Internal B. Respiratory B. Respiratory C. Other Internal D. Other C. Other Internal C. Other Internal C. Other Internal A. Heart and Circulatory A. Heart and Circulatory D. Other C. Other Internal C. Other Internal C. Other Internal B. Respiratory C. Other Internal C. Other Internal C. Other Internal C. Other Internal C. Other Internal D. Other D. Other C. Other Internal A. Heart and Circulatory D. Other C. Other Internal A. Heart and Circulatory C. Other Internal C. Other Internal C. Other Internal C. Other Internal C. Other Internal A. Heart and Circulatory D. Other D. Other C. Other Internal B. Respiratory A. Heart and Circulatory C. Other Internal B. Respiratory B. Respiratory A. Heart and Circulatory D. Other C. Other Internal C. Other Internal A. Heart and Circulatory C. Other Internal C. Other Internal D. Other 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 M M M M M M M F M F M F F F F F M F F M F F M F F F F M M F F F M F F F M M F F F F M F M F F F M F F F M F 140 96 175 209 183 79 144 143 78 493 316 143 122 358 140 89 209 294 15 96 89 140 207 473 321 175 183 140 127 209 88 209 89 294 140 89 241 336 143 321 296 248 278 493 183 175 88 15 89 87 140 444 140 321 A. Heart and Circulatory B. Respiratory C. Other Internal D. Other C. Other Internal B. Respiratory A. Heart and Circulatory A. Heart and Circulatory B. Respiratory C. Other Internal C. Other Internal A. Heart and Circulatory A. Heart and Circulatory C. Other Internal A. Heart and Circulatory B. Respiratory D. Other C. Other Internal C. Other Internal B. Respiratory B. Respiratory A. Heart and Circulatory C. Other Internal D. Other C. Other Internal C. Other Internal C. Other Internal A. Heart and Circulatory A. Heart and Circulatory D. Other B. Respiratory D. Other B. Respiratory C. Other Internal A. Heart and Circulatory B. Respiratory D. Other C. Other Internal A. Heart and Circulatory C. Other Internal C. Other Internal D. Other D. Other C. Other Internal C. Other Internal C. Other Internal B. Respiratory C. Other Internal B. Respiratory B. Respiratory A. Heart and Circulatory D. Other A. Heart and Circulatory C. Other Internal 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 F M F F F F F F F M F F F F F F M F M M M F M M M F F F F F F F F M F F F F F M F F F F F F M F F M M F M M 324 294 89 88 141 127 127 88 89 335 430 473 15 148 127 182 78 473 294 269 89 128 278 90 89 203 143 140 143 15 88 321 15 236 127 127 88 143 143 335 294 138 321 122 140 87 182 166 321 79 140 122 89 14 C. Other Internal C. Other Internal B. Respiratory B. Respiratory A. Heart and Circulatory A. Heart and Circulatory A. Heart and Circulatory B. Respiratory B. Respiratory C. Other Internal C. Other Internal D. Other C. Other Internal C. Other Internal A. Heart and Circulatory C. Other Internal B. Respiratory D. Other C. Other Internal D. Other B. Respiratory A. Heart and Circulatory D. Other B. Respiratory B. Respiratory C. Other Internal A. Heart and Circulatory A. Heart and Circulatory A. Heart and Circulatory C. Other Internal B. Respiratory C. Other Internal C. Other Internal D. Other A. Heart and Circulatory A. Heart and Circulatory B. Respiratory A. Heart and Circulatory A. Heart and Circulatory C. Other Internal C. Other Internal A. Heart and Circulatory C. Other Internal A. Heart and Circulatory A. Heart and Circulatory B. Respiratory C. Other Internal C. Other Internal C. Other Internal B. Respiratory A. Heart and Circulatory A. Heart and Circulatory B. Respiratory C. Other Internal 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 F F F F F M F F F F F M F F M F M M F M F M M F F F M M M F F 240 240 90 127 128 207 122 140 430 159 138 140 90 122 336 296 183 140 140 144 197 89 241 141 132 139 346 127 316 159 296 D. Other D. Other B. Respiratory A. Heart and Circulatory A. Heart and Circulatory C. Other Internal A. Heart and Circulatory A. Heart and Circulatory C. Other Internal C. Other Internal A. Heart and Circulatory A. Heart and Circulatory B. Respiratory A. Heart and Circulatory C. Other Internal C. Other Internal C. Other Internal A. Heart and Circulatory A. Heart and Circulatory A. Heart and Circulatory C. Other Internal B. Respiratory D. Other A. Heart and Circulatory A. Heart and Circulatory A. Heart and Circulatory C. Other Internal A. Heart and Circulatory C. Other Internal C. Other Internal C. Other Internal UTI Adequate by 2+ Adequate by 1 Adequate by 0 Hyper 13 17 77 107 Ulcer 31 29 54 114 25 12 38 75 69 58 169 296 Ward General Pediatric General General General Geriatric General General Pediatric General Geriatric Geriatric General Geriatric General Pediatric Pediatric Geriatric General Geriatric General Pediatric General General Pediatric General General General General General General General General General General Pediatric Pediatric General General Geriatric General General Geriatric General General Pediatric Pediatric Pediatric General Reason Facility Personnel Personnel Personnel Facility Patient Patient Facility Patient Personnel Facility Personnel Patient Facility Personnel Patient Personnel Personnel Personnel Personnel Patient Patient Patient Facility Patient Personnel Personnel Personnel Personnel Patient Patient Personnel Patient Patient Patient Patient Patient Patient Patient Personnel Patient Facility Personnel Personnel Patient Personnel Patient Personnel Facility General Geriatric Pediatric General Geriatric General General General General General General General General General General General General General General General Pediatric Pediatric Geriatric Pediatric General General Geriatric General General General Pediatric General Pediatric Pediatric Geriatric General General Geriatric General Pediatric General Geriatric Pediatric Geriatric General Geriatric Pediatric General Geriatric General Personnel Patient Facility Personnel Patient Personnel Patient Patient Facility Personnel Facility Personnel Patient Personnel Personnel Personnel Personnel Personnel Personnel Patient Facility Personnel Personnel Personnel Facility Facility Patient Personnel Personnel Patient Personnel Facility Personnel Personnel Facility Personnel Patient Personnel Personnel Facility Patient Patient Patient Patient Personnel Facility Personnel Personnel Personnel Facility General General General Geriatric General General Geriatric Geriatric General General General General Pediatric General General Geriatric General Pediatric General Pediatric General Pediatric General General Geriatric General General General General Pediatric General General General General General General Pediatric Geriatric Pediatric General General General Geriatric Geriatric General Geriatric Geriatric Geriatric General Geriatric Personnel Patient Patient Facility Personnel Facility Personnel Patient Personnel Facility Patient Patient Personnel Patient Personnel Personnel Personnel Personnel Personnel Facility Personnel Personnel Patient Facility Personnel Personnel Patient Personnel Personnel Patient Patient Personnel Facility Facility Patient Facility Facility Patient Personnel Patient Facility Facility Personnel Personnel Personnel Facility Facility Personnel Personnel Patient General Pediatric General Geriatric General General Pediatric General Geriatric General Geriatric Pediatric Geriatric Pediatric Pediatric General General Geriatric General Geriatric Pediatric General Pediatric General Geriatric Geriatric Pediatric Pediatric Pediatric General Pediatric General Pediatric General General General Geriatric General General Pediatric General Geriatric Pediatric General General Geriatric General General General Pediatric Facility Patient Patient Facility Personnel Personnel Facility Facility Personnel Personnel Facility Facility Personnel Patient Patient Patient Patient Patient Facility Patient Facility Patient Facility Personnel Patient Personnel Patient Personnel Personnel Personnel Facility Patient Facility Patient Personnel Patient Patient Patient Personnel Facility Patient Patient Personnel Patient Personnel Patient Personnel Personnel Facility Personnel Geriatric General Pediatric General Geriatric General Pediatric General Geriatric Geriatric General General Geriatric General Pediatric Pediatric Geriatric Geriatric General Geriatric General General General Geriatric Geriatric Geriatric General General General General Geriatric Pediatric General Pediatric General General General General General Geriatric General Geriatric Geriatric General General General General General General Pediatric Personnel Facility Facility Facility Personnel Personnel Personnel Personnel Personnel Patient Personnel Facility Patient Patient Patient Personnel Patient Facility Personnel Personnel Facility Patient Facility Personnel Facility Personnel Personnel Patient Personnel Patient Personnel Personnel Facility Personnel Patient Personnel Patient Patient Personnel Patient Personnel Facility Patient Patient Personnel Personnel Facility Personnel Facility Personnel General Geriatric General General Pediatric Pediatric General Geriatric General General General General Pediatric Geriatric Geriatric General General General Pediatric Pediatric General General Geriatric General Geriatric General General General General General Geriatric General General Pediatric General General Geriatric Geriatric General Geriatric Geriatric General Pediatric Pediatric Pediatric Geriatric Pediatric Geriatric General Pediatric Patient Patient Facility Personnel Facility Personnel Facility Personnel Personnel Personnel Patient Facility Personnel Patient Personnel Personnel Personnel Personnel Personnel Patient Patient Personnel Personnel Patient Patient Personnel Patient Personnel Personnel Facility Patient Personnel Patient Facility Patient Personnel Personnel Facility Personnel Personnel Personnel Patient Facility Personnel Patient Personnel Patient Patient Personnel Facility Geriatric General General General General General General General General General Geriatric Geriatric General General Geriatric Pediatric Geriatric General Geriatric General General Pediatric General General General Pediatric General General Pediatric General Geriatric General General General General General Pediatric General General General Geriatric Pediatric General General General General General Pediatric General Pediatric Personnel Personnel Personnel Personnel Patient Patient Personnel Facility Patient Patient Patient Patient Facility Personnel Facility Personnel Personnel Personnel Personnel Personnel Patient Personnel Patient Personnel Personnel Patient Facility Patient Personnel Facility Patient Personnel Facility Personnel Facility Personnel Personnel Facility Patient Personnel Patient Personnel Patient Facility Facility Personnel Facility Personnel Patient Patient General Pediatric Geriatric General Geriatric General Geriatric Geriatric General Pediatric Pediatric Geriatric General Geriatric General Geriatric Pediatric Geriatric General General General General General Pediatric Pediatric General Geriatric General General Geriatric General Geriatric General Geriatric Geriatric General Pediatric General General Geriatric Geriatric Geriatric Geriatric General Pediatric Pediatric General Pediatric Pediatric Geriatric Personnel Personnel Personnel Personnel Facility Patient Patient Personnel Patient Patient Personnel Patient Patient Patient Personnel Personnel Patient Patient Facility Personnel Patient Patient Facility Patient Personnel Personnel Facility Facility Personnel Facility Patient Facility Patient Personnel Personnel Personnel Patient Personnel Patient Personnel Personnel Facility Patient Patient Personnel Patient Personnel Facility Patient Personnel Pediatric General Pediatric Geriatric Geriatric General General General General General General Pediatric General General General General General Geriatric Geriatric Geriatric General General Pediatric General General General Geriatric General General Pediatric General General General General Geriatric General General General Pediatric General Geriatric Geriatric Pediatric General Pediatric Pediatric General General General General Facility Facility Personnel Personnel Patient Facility Personnel Personnel Facility Patient Personnel Patient Patient Patient Facility Patient Facility Personnel Personnel Facility Personnel Facility Personnel Facility Facility Patient Personnel Patient Personnel Patient Personnel Personnel Personnel Patient Patient Personnel Personnel Personnel Facility Patient Personnel Personnel Patient Personnel Patient Personnel Personnel Facility Personnel Personnel General General Geriatric General Pediatric General General General General Geriatric General Geriatric General Geriatric Geriatric General General General General General Geriatric General Geriatric General General Facility Patient Personnel Patient Patient Patient Personnel Patient Facility Facility Patient Facility Personnel Patient Personnel Patient Patient Facility Personnel Patient Personnel Patient Personnel Patient Patient Day Emergency Other Night 5 25 30 10 10 20 15 35 50 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Sex Male Female Female Male Female Female Male Female Female Male Female Female Male Male Male Female Female Female Male Male Female Male Male Male Female Female Male Female Female Male Male Female Female Male Female Opinion Favorable Unfavorable Favorable Favorable Unfavorable Unfavorable Favorable Favorable Unfavorable Unfavorable Unfavorable Favorable Unfavorable Unfavorable Unfavorable Unfavorable Favorable Favorable Favorable Favorable Favorable Favorable Unfavorable Unfavorable Favorable Favorable Favorable Unfavorable Unfavorable Favorable Favorable Unfavorable Favorable Unfavorable Favorable \f\f\f\f\f\f\f\f\f11.1 Problem 1, Problem 2, Problem 5 11.3 Problem 1 part a 11.1-1 See Hospital Charges Tab Chart (c) best fits a linear model, while chart (b) appears to be the worst. Correlations were checked and (c) has the highes 11.1-5 a 12 a. b1 b0 0.5 b. b1 b0 1.2 c. b1 x b0 b1 225 321 452 511 534 6 4 2 0 2 4 6 8 2390 2505.2 2662.4 2733.2 150 231 344 427 424.5 365.37 282.88 222.29 y 40 60 80 100 f(x) = 0.5x + 3 8 0 y x 60 10 4 5.5 7.5 10 y x b0 0.0002 y 2 5 9 14 2120 -0.73 d. x 3 60.008 60.012 60.016 60.02 450 400 350 300 250 200 150 100 50 0 100 10 12 14 16 c f(x) = - 0.73x + 534 150 200 250 300 350 400 450 d 60.025 60.02 f(x) = 0.0002x + 60 60.015 60.01 60.005 60 30 40 50 60 70 80 90 100 110 e checked and (c) has the highest correlation, with (b) the lowest. 10 12 350 80 400 90 b 16 2800 2700 2600 2500 2400 2300 2200 200 300 0 14 100 450 110 f(x) = 1.2x + 2120 250 300 350 400 450 500 550 Sex Sex1 Age LOS Charges Medicare Diag ICD-9 DRG F 1 46 4 $ 2,426.48 $ 2,003.62 2 0 294 F 1 87 8 $ 6,815.61 $ 1,072.17 4 4 139 F 1 70 10 $ 7,596.68 $ 4,096.98 6 0 34 M 0 72 5 $ 6,450.77 $ 1,710.79 5 0 140 F 1 82 3 $ 3,542.79 $ 1,914.90 3 7 141 F 1 85 2 $ 2,590.86 $ 2,601.14 5 4 15 F 1 73 5 $ 5,082.83 $ 2,035.31 7 2 294 M 0 65 6 $ 3,580.55 $ 2,320.42 6 0 241 M 0 73 6 $ 11,045.79 $ 4,184.26 1 0 335 F 1 94 14 $ 19,708.11 $ 12,158.49 4 0 148 F 1 94 11 $ 8,953.38 $ 4,345.84 4 0 89 M 0 79 5 $ 7,000.21 $ 3,993.48 5 0 127 M 0 82 6 $ 5,330.24 $ 3,408.07 4 0 89 F 1 76 3 $ 6,864.63 $ 3,637.35 5 4 122 M 0 72 3 $ 4,318.13 $ 2,676.01 2 0 336 F 1 91 7 $ 6,424.30 $ 1,510.20 3 0 321 F 1 90 6 $ 5,184.53 $ 3,642.44 6 5 174 F 1 83 3 $ 1,871.78 $ 1,167.65 6 0 143 F 1 82 11 $ 11,179.97 $ 3,432.13 9 6 358 F 1 49 2 $ 3,405.38 $ 1,710.79 1 0 140 F 1 88 2 $ 1,731.73 $ 1,979.28 4 7 143 F 1 75 2 $ 5,384.92 $ 3,316.59 2 0 159 M 0 81 7 $ 5,216.91 $ 3,613.06 2 4 89 F 1 76 4 $ 2,489.65 $ 2,201.93 3 0 294 F 1 85 10 $ 8,244.25 $ 12,772.75 4 0 473 F 1 84 6 $ 3,548.05 $ 2,163.29 8 4 128 F 1 77 3 $ 4,713.26 $ 1,801.73 4 0 15 F 1 94 6 $ 5,804.21 $ 5,282.36 5 7 121 F 1 66 6 $ 2,945.22 $ 2,849.72 2 0 128 M 0 72 1 $ 1,035.75 $ 1,685.62 5 4 140 M 0 78 3 $ 17,005.45 $ 7,534.44 1 7 209 F 1 86 3 $ 4,637.96 $ 1,447.84 5 0 143 F 1 70 5 $ 17,480.97 $ 7,566.98 5 0 209 M 0 72 5 $ 5,029.09 $ 3,306.80 8 4 96 M 0 91 3 $ 3,078.99 $ 3,351.64 5 4 144 M 0 75 2 $ 2,146.99 $ 1,968.05 2 4 90 F 1 83 6 $ 5,482.93 $ 3,147.39 2 0 88 M 0 82 1 $ 1,078.56 $ 1,386.42 6 5 183 F 1 82 10 $ 9,931.21 $ 3,530.00 1 0 430 F 1 92 2 $ 2,451.69 $ 2,266.56 2 4 138 F 1 79 2 $ 2,834.68 $ 3,579.24 1 0 88 F 1 69 2 $ 1,547.81 $ 988.00 3 0 447 F 1 76 3 $ 1,876.70 $ 1,235.80 1 0 183 M 0 73 2 $ 2,781.28 $ 1,483.79 4 0 140 F 1 83 6 $ 6,460.59 $ 3,993.48 5 0 127 F 1 80 4 $ 3,026.42 $ 1,918.32 1 6 444 F 1 76 10 $ 14,769.92 $ 5,594.68 4 5 493 F 1 77 7 $ 4,425.44 $ 1,531.55 5 5 324 F 1 85 4 $ 5,151.52 $ 1,710.79 5 0 140 F 1 70 1 $ 2,404.39 $ 735.58 1 4 140 M 0 81 2 $ 5,019.86 $ 1,730.79 2 0 140 18 16 14 LOS 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 12 10 8 6 4 2 0 35 45 $14,000.00 Medicare ID $12,000.00 $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 $- Medic $10,000.00 $8,000.00 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 F M F M F M F M F F M F F F F F F M F M M F F F M M M M F M F F M F F M F F M F F M F F F M M M M 1 0 1 0 1 0 1 0 1 1 0 1 1 1 1 1 1 0 1 0 0 1 1 1 0 0 0 0 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 1 0 0 0 0 83 76 88 88 89 39 89 80 71 90 91 73 77 78 79 85 74 78 92 56 76 84 75 68 50 49 76 76 67 96 83 77 86 80 61 80 78 71 90 91 69 88 76 83 75 83 68 75 60 9 2 3 4 2 1 5 12 7 4 4 1 7 2 4 14 1 10 2 1 2 10 3 7 2 9 3 3 2 11 16 3 5 1 8 5 2 10 9 7 4 5 2 5 3 7 9 7 5 $ 10,421.01 $ 4,860.83 $ 2,694.11 $ 2,421.63 $ 3,311.66 $ 1,596.91 $ 5,399.67 $ 17,605.59 $ 11,098.70 $ 3,674.03 $ 3,720.09 $ 2,472.64 $ 7,792.24 $ 3,489.88 $ 4,655.83 $ 10,242.50 $ 1,599.82 $ 6,015.34 $ 1,905.65 $ 707.70 $ 3,004.67 $ 18,290.04 $ 5,621.92 $ 5,547.71 $ 2,581.72 $ 7,024.64 $ 4,242.10 $ 4,286.90 $ 12,313.78 $ 8,217.27 $ 10,655.80 $ 3,620.78 $ 4,734.98 $ 1,820.41 $ 8,954.81 $ 4,177.90 $ 5,756.89 $ 12,919.48 $ 7,022.47 $ 6,823.60 $ 2,384.47 $ 3,169.19 $ 2,721.63 $ 3,034.14 $ 5,041.93 $ 8,118.92 $ 10,955.29 $ 5,363.25 $ 6,572.60 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2,384.12 5,688.67 1,564.50 1,346.94 2,065.49 392.00 3,048.91 4,432.93 4,256.70 3,609.84 4,269.96 2,356.05 4,538.13 1,430.32 3,965.21 4,531.65 2,628.95 2,003.62 3,993.48 2,102.01 1,423.87 6,862.34 1,772.78 4,565.48 2,238.61 2,441.00 1,344.35 3,045.51 2,393.04 5,462.63 3,277.48 2,064.43 3,731.44 1,564.50 3,351.61 2,314.57 2,156.63 2,711.94 2,589.84 3,516.57 2,084.09 2,131.82 1,150.43 1,630.16 3,645.46 1,730.79 5,662.61 3,409.08 3,892.79 5 4 2 2 3 5 4 9 3 3 6 4 1 3 9 6 3 5 5 3 4 5 5 5 3 5 4 2 3 4 5 5 2 2 4 6 3 3 2 6 5 4 6 7 1 5 8 5 6 0 1 0 0 0 3 4 7 4 0 2 0 5 5 6 0 0 0 0 2 5 0 7 7 5 0 5 5 0 0 0 5 0 0 2 0 4 0 0 4 0 0 7 0 4 0 4 5 4 138 269 140 208 15 434 88 78 89 89 316 140 166 175 203 87 296 294 127 294 183 197 132 240 182 436 175 207 359 79 127 182 346 140 296 236 122 90 89 296 248 278 143 321 127 140 79 101 14 $6,000.00 $4,000.00 $2,000.00 $- $- $5, LOS Medicare Correlation Age vs. LOS Age LOS 18 16 14 12 10 8 6 4 2 0 35 45 55 65Age 75 85 95 Correlation Age Charges Charges vs. Medicare $14,000.00 $12,000.00 $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 $- Charges Medicare Medic $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 $- $- $5,000.00 $10,000.00 Charges $15,000.00 $20,000.00 $25,000.00 Correlation Age 1 0.227328 LOS 1 Correlation Age 1 0.111163 Charges 1 Charges Medicare 1 0.663281 1 \f\f11.1 Problem 1, Problem 2, Problem 5 11.3 Problem 1 part a 11.1-1 See Hospital Charges Tab Chart (c) best fits a linear model, while chart (b) appears to be the worst. Correlations were checked and (c) has the highes 11.1-5 a 12 a. b1 b0 0.5 b. b1 b0 1.2 c. b1 x b0 b1 225 321 452 511 534 6 4 2 0 2 4 6 8 2390 2505.2 2662.4 2733.2 150 231 344 427 424.5 365.37 282.88 222.29 y 40 60 80 100 f(x) = 0.5x + 3 8 0 y x 60 10 4 5.5 7.5 10 y x b0 0.0002 y 2 5 9 14 2120 -0.73 d. x 3 60.008 60.012 60.016 60.02 450 400 350 300 250 200 150 100 50 0 100 10 12 14 16 c f(x) = - 0.73x + 534 150 200 250 300 350 400 450 d 60.025 60.02 f(x) = 0.0002x + 60 60.015 60.01 60.005 60 30 40 50 60 70 80 90 100 110 e checked and (c) has the highest correlation, with (b) the lowest. 10 12 350 80 400 90 b 16 2800 2700 2600 2500 2400 2300 2200 200 300 0 14 100 450 110 f(x) = 1.2x + 2120 250 300 350 400 450 500 550 Sex Sex1 Age LOS Charges Medicare Diag ICD-9 DRG F 1 46 4 $ 2,426.48 $ 2,003.62 2 0 294 F 1 87 8 $ 6,815.61 $ 1,072.17 4 4 139 F 1 70 10 $ 7,596.68 $ 4,096.98 6 0 34 M 0 72 5 $ 6,450.77 $ 1,710.79 5 0 140 F 1 82 3 $ 3,542.79 $ 1,914.90 3 7 141 F 1 85 2 $ 2,590.86 $ 2,601.14 5 4 15 F 1 73 5 $ 5,082.83 $ 2,035.31 7 2 294 M 0 65 6 $ 3,580.55 $ 2,320.42 6 0 241 M 0 73 6 $ 11,045.79 $ 4,184.26 1 0 335 F 1 94 14 $ 19,708.11 $ 12,158.49 4 0 148 F 1 94 11 $ 8,953.38 $ 4,345.84 4 0 89 M 0 79 5 $ 7,000.21 $ 3,993.48 5 0 127 M 0 82 6 $ 5,330.24 $ 3,408.07 4 0 89 F 1 76 3 $ 6,864.63 $ 3,637.35 5 4 122 M 0 72 3 $ 4,318.13 $ 2,676.01 2 0 336 F 1 91 7 $ 6,424.30 $ 1,510.20 3 0 321 F 1 90 6 $ 5,184.53 $ 3,642.44 6 5 174 F 1 83 3 $ 1,871.78 $ 1,167.65 6 0 143 F 1 82 11 $ 11,179.97 $ 3,432.13 9 6 358 F 1 49 2 $ 3,405.38 $ 1,710.79 1 0 140 F 1 88 2 $ 1,731.73 $ 1,979.28 4 7 143 F 1 75 2 $ 5,384.92 $ 3,316.59 2 0 159 M 0 81 7 $ 5,216.91 $ 3,613.06 2 4 89 F 1 76 4 $ 2,489.65 $ 2,201.93 3 0 294 F 1 85 10 $ 8,244.25 $ 12,772.75 4 0 473 F 1 84 6 $ 3,548.05 $ 2,163.29 8 4 128 F 1 77 3 $ 4,713.26 $ 1,801.73 4 0 15 F 1 94 6 $ 5,804.21 $ 5,282.36 5 7 121 F 1 66 6 $ 2,945.22 $ 2,849.72 2 0 128 M 0 72 1 $ 1,035.75 $ 1,685.62 5 4 140 M 0 78 3 $ 17,005.45 $ 7,534.44 1 7 209 F 1 86 3 $ 4,637.96 $ 1,447.84 5 0 143 F 1 70 5 $ 17,480.97 $ 7,566.98 5 0 209 M 0 72 5 $ 5,029.09 $ 3,306.80 8 4 96 M 0 91 3 $ 3,078.99 $ 3,351.64 5 4 144 M 0 75 2 $ 2,146.99 $ 1,968.05 2 4 90 F 1 83 6 $ 5,482.93 $ 3,147.39 2 0 88 M 0 82 1 $ 1,078.56 $ 1,386.42 6 5 183 F 1 82 10 $ 9,931.21 $ 3,530.00 1 0 430 F 1 92 2 $ 2,451.69 $ 2,266.56 2 4 138 F 1 79 2 $ 2,834.68 $ 3,579.24 1 0 88 F 1 69 2 $ 1,547.81 $ 988.00 3 0 447 F 1 76 3 $ 1,876.70 $ 1,235.80 1 0 183 M 0 73 2 $ 2,781.28 $ 1,483.79 4 0 140 F 1 83 6 $ 6,460.59 $ 3,993.48 5 0 127 F 1 80 4 $ 3,026.42 $ 1,918.32 1 6 444 F 1 76 10 $ 14,769.92 $ 5,594.68 4 5 493 F 1 77 7 $ 4,425.44 $ 1,531.55 5 5 324 F 1 85 4 $ 5,151.52 $ 1,710.79 5 0 140 F 1 70 1 $ 2,404.39 $ 735.58 1 4 140 M 0 81 2 $ 5,019.86 $ 1,730.79 2 0 140 18 16 14 LOS 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 12 10 8 6 4 2 0 35 45 $14,000.00 Medicare ID $12,000.00 $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 $- Medic $10,000.00 $8,000.00 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 F M F M F M F M F F M F F F F F F M F M M F F F M M M M F M F F M F F M F F M F F M F F F M M M M 1 0 1 0 1 0 1 0 1 1 0 1 1 1 1 1 1 0 1 0 0 1 1 1 0 0 0 0 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 1 1 0 0 0 0 83 76 88 88 89 39 89 80 71 90 91 73 77 78 79 85 74 78 92 56 76 84 75 68 50 49 76 76 67 96 83 77 86 80 61 80 78 71 90 91 69 88 76 83 75 83 68 75 60 9 2 3 4 2 1 5 12 7 4 4 1 7 2 4 14 1 10 2 1 2 10 3 7 2 9 3 3 2 11 16 3 5 1 8 5 2 10 9 7 4 5 2 5 3 7 9 7 5 $ 10,421.01 $ 4,860.83 $ 2,694.11 $ 2,421.63 $ 3,311.66 $ 1,596.91 $ 5,399.67 $ 17,605.59 $ 11,098.70 $ 3,674.03 $ 3,720.09 $ 2,472.64 $ 7,792.24 $ 3,489.88 $ 4,655.83 $ 10,242.50 $ 1,599.82 $ 6,015.34 $ 1,905.65 $ 707.70 $ 3,004.67 $ 18,290.04 $ 5,621.92 $ 5,547.71 $ 2,581.72 $ 7,024.64 $ 4,242.10 $ 4,286.90 $ 12,313.78 $ 8,217.27 $ 10,655.80 $ 3,620.78 $ 4,734.98 $ 1,820.41 $ 8,954.81 $ 4,177.90 $ 5,756.89 $ 12,919.48 $ 7,022.47 $ 6,823.60 $ 2,384.47 $ 3,169.19 $ 2,721.63 $ 3,034.14 $ 5,041.93 $ 8,118.92 $ 10,955.29 $ 5,363.25 $ 6,572.60 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2,384.12 5,688.67 1,564.50 1,346.94 2,065.49 392.00 3,048.91 4,432.93 4,256.70 3,609.84 4,269.96 2,356.05 4,538.13 1,430.32 3,965.21 4,531.65 2,628.95 2,003.62 3,993.48 2,102.01 1,423.87 6,862.34 1,772.78 4,565.48 2,238.61 2,441.00 1,344.35 3,045.51 2,393.04 5,462.63 3,277.48 2,064.43 3,731.44 1,564.50 3,351.61 2,314.57 2,156.63 2,711.94 2,589.84 3,516.57 2,084.09 2,131.82 1,150.43 1,630.16 3,645.46 1,730.79 5,662.61 3,409.08 3,892.79 5 4 2 2 3 5 4 9 3 3 6 4 1 3 9 6 3 5 5 3 4 5 5 5 3 5 4 2 3 4 5 5 2 2 4 6 3 3 2 6 5 4 6 7 1 5 8 5 6 0 1 0 0 0 3 4 7 4 0 2 0 5 5 6 0 0 0 0 2 5 0 7 7 5 0 5 5 0 0 0 5 0 0 2 0 4 0 0 4 0 0 7 0 4 0 4 5 4 138 269 140 208 15 434 88 78 89 89 316 140 166 175 203 87 296 294 127 294 183 197 132 240 182 436 175 207 359 79 127 182 346 140 296 236 122 90 89 296 248 278 143 321 127 140 79 101 14 $6,000.00 $4,000.00 $2,000.00 $- $- $5, LOS Medicare Correlation Age vs. LOS Age LOS 18 16 14 12 10 8 6 4 2 0 35 45 55 65Age 75 85 95 Correlation Age Charges Charges vs. Medicare $14,000.00 $12,000.00 $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 $- Charges Medicare Medic $10,000.00 $8,000.00 $6,000.00 $4,000.00 $2,000.00 $- $- $5,000.00 $10,000.00 Charges $15,000.00 $20,000.00 $25,000.00 Correlation Age 1 0.227328 LOS 1 Correlation Age 1 0.111163 Charges 1 Charges Medicare 1 0.663281 1 \f\f
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started