ID Sex Sex1 Age LOS DRG Charges Medicare Diag ICD-9 4 M 0 72 5 140 $ 6,450.77 $ 1,710.79 5 0 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 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 15 M 0 72 3 336 $ 4,318.13 $ 2,676.01 2 0 23 M 0 81 7 89 $ 5,216.91 $ 3,613.06 2 4 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 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 38 M 0 82 1 183 $ 1,078.56 $ 1,386.42 6 5 44 M 0 73 2 140 $ 2,781.28 $ 1,483.79 4 0 51 M 0 81 2 140 $ 5,019.86 $ 1,730.79 2 0 53 M 0 76 2 269 $ 4,860.83 $ 5,688.67 4 1 55 M 0 88 4 208 $ 2,421.63 $ 1,346.94 2 0 57 M 0 39 1 434 $ 1,596.91 $ 392.00 5 3 59 M 0 80 12 78 $17,605.59 $ 4,432.93 9 7 62 M 0 91 4 316 $ 3,720.09 $ 4,269.96 6 2 69 M 0 78 10 294 $ 6,015.34 $ 2,003.62 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 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 81 M 0 96 11 79 $ 8,217.27 $ 5,462.63 4 0 84 M 0 86 5 346 $ 4,734.98 $ 3,731.44 2 0 87 M 0 80 5 236 $ 4,177.90 $ 2,314.57 6 0 90 M 0 90 9 89 $ 7,022.47 $ 2,589.84 2 0 93 M 0 88 5 278 $ 3,169.19 $ 2,131.82 4 0 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 1 F 1 46 4 294 $ 2,426.48 $ 2,003.62 2 0 2 F 1 87 8 139 $ 6,815.61 $ 1,072.17 4 4 3 F 1 70 10 34 $ 7,596.68 $ 4,096.98 6 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 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 14 F 1 76 3 122 $ 6,864.63 $ 3,637.35 5 4 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 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 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 37 F 1 83 6 88 $ 5,482.93 $ 3,147.39 2 0 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 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 52 F 1 83 9 138 $10,421.01 $ 2,384.12 5 0 54 F 1 88 3 140 $ 2,694.11 $ 1,564.50 2 0 56 F 1 89 2 15 $ 3,311.66 $ 2,065.49 3 0 58 F 1 89 5 88 $ 5,399.67 $ 3,048.91 4 4 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 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 70 F 1 92 2 127 $ 1,905.65 $ 3,993.48 5 0 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 80 F 1 67 2 359 $12,313.78 $ 2,393.04 3 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 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 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 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 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 3.347 110 4066.69415
Use the hospital charge worksheet in the file Chpt 4-1.xls. Assume that the data represent a random sample from a larger population and do the following: a. Calculate the exact 95 percent upper and lower confidence limits for the population mean of LOS. b. Calculate the exact 95 percent upper and lower confidence limits for the population mean of charges. c. Calculate the exact 95 percent upper limit only for the population mean of charges-that is, the value below which 95 percent of all sample means will be respected to fall. d. Calculate the exact 95 percent upper and lower confidence limits for the population proportion, which is female.
