Hi, I need help with these questions please.

Use the Hospital Charges worksheet in the file Chp.4-1.xls. Assume that the data repreent a random sample from a larger population and do the following.

a. Calculate the exact 95 % upper and lower confidence limits for the population mean of LOS

b. Calculate the exact 95 % upper and lower confidence limits for the population mean of Charges.

c. Calculate the exact 95 % upper limit only for the population mean of charges - that is the value below which 95 percent if all sample means will be expected to fall.

d. Calculate the exact 95 % upper and lower confidence limits for the population proportion, which is female.

I am attaching the file that is needed to answer this question.

Thanks in advance for your help.

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 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 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 F 1 88 3 140 M 0 88 4 208 F 1 89 2 15 M 0 39 1 434 F 1 89 5 88 M 0 80 12 78 F 1 71 7 89 F 1 90 4 89 M 0 91 4 316 F 1 73 1 140 F 1 77 7 166 F 1 78 2 175 F 1 79 4 203 F 1 85 14 87 F 1 74 1 296 M 0 78 10 294 F 1 92 2 127 M 0 56 1 294 M 0 76 2 183 F 1 84 10 197 F 1 75 3 132 F 1 68 7 240 M 0 50 2 182 M 0 49 9 436 M 0 76 3 175 M 0 76 3 207 F 1 67 2 359 M 0 96 11 79 F 1 83 16 127 F 1 77 3 182 M 0 86 5 346 F 1 80 1 140 F 1 61 8 296 M 0 80 5 236 F 1 78 2 122 F 1 71 10 90 M 0 90 9 89 F 1 91 7 296 F 1 69 4 248 M 0 88 5 278 F 1 76 2 143 F 1 83 5 321 Charges $ 2,426.48 $ 6,815.61 $ 7,596.68 $ 6,450.77 $ 3,542.79 $ 2,590.86 $ 5,082.83 $ 3,580.55 $ 11,045.79 $ 19,708.11 $ 8,953.38 $ 7,000.21 $ 5,330.24 $ 6,864.63 $ 4,318.13 $ 6,424.30 $ 5,184.53 $ 1,871.78 $ 11,179.97 $ 3,405.38 $ 1,731.73 $ 5,384.92 $ 5,216.91 $ 2,489.65 $ 8,244.25 $ 3,548.05 $ 4,713.26 $ 5,804.21 $ 2,945.22 $ 1,035.75 $ 17,005.45 $ 4,637.96 $ 17,480.97 $ 5,029.09 $ 3,078.99 $ 2,146.99 $ 5,482.93 $ 1,078.56 $ 9,931.21 $ 2,451.69 $ 2,834.68 $ 1,547.81 $ 1,876.70 $ 2,781.28 $ 6,460.59 $ 3,026.42 $ 14,769.92 $ 4,425.44 $ 5,151.52 $ 2,404.39 $ 5,019.86 $ 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 Medicare Diag ICD-9 $ 2,003.62 2 0 $ 1,072.17 4 4 $ 4,096.98 6 0 $ 1,710.79 5 0 $ 1,914.90 3 7 $ 2,601.14 5 4 $ 2,035.31 7 2 $ 2,320.42 6 0 $ 4,184.26 1 0 $ 12,158.49 4 0 $ 4,345.84 4 0 $ 3,993.48 5 0 $ 3,408.07 4 0 $ 3,637.35 5 4 $ 2,676.01 2 0 $ 1,510.20 3 0 $ 3,642.44 6 5 $ 1,167.65 6 0 $ 3,432.13 9 6 $ 1,710.79 1 0 $ 1,979.28 4 7 $ 3,316.59 2 0 $ 3,613.06 2 4 $ 2,201.93 3 0 $ 12,772.75 4 0 $ 2,163.29 8 4 $ 1,801.73 4 0 $ 5,282.36 5 7 $ 2,849.72 2 0 $ 1,685.62 5 4 $ 7,534.44 1 7 $ 1,447.84 5 0 $ 7,566.98 5 0 $ 3,306.80 8 4 $ 3,351.64 5 4 $ 1,968.05 2 4 $ 3,147.39 2 0 $ 1,386.42 6 5 $ 3,530.00 1 0 $ 2,266.56 2 4 $ 3,579.24 1 0 $ 988.00 3 0 $ 1,235.80 1 0 $ 1,483.79 4 0 $ 3,993.48 5 0 $ 1,918.32 1 6 $ 5,594.68 4 5 $ 1,531.55 5 5 $ 1,710.79 5 0 $ 735.58 1 4 $ 1,730.79 2 0 $ 2,384.12 5 0 $ 5,688.67 4 1 $ 1,564.50 2 0 $ 1,346.94 2 0 $ 2,065.49 3 0 $ 392.00 5 3 $ 3,048.91 4 4 $ 4,432.93 9 7 $ 4,256.70 3 4 $ 3,609.84 3 0 $ 4,269.96 6 2 $ 2,356.05 4 0 $ 4,538.13 1 5 $ 1,430.32 3 5 $ 3,965.21 9 6 $ 4,531.65 6 0 $ 2,628.95 3 0 $ 2,003.62 5 0 $ 3,993.48 5 0 $ 2,102.01 3 2 $ 1,423.87 4 5 $ 6,862.34 5 0 $ 1,772.78 5 7 $ 4,565.48 5 7 $ 2,238.61 3 5 $ 2,441.00 5 0 $ 1,344.35 4 5 $ 3,045.51 2 5 $ 2,393.04 3 0 $ 5,462.63 4 0 $ 3,277.48 5 0 $ 2,064.43 5 5 $ 3,731.44 2 0 $ 1,564.50 2 0 $ 3,351.61 4 2 $ 2,314.57 6 0 $ 2,156.63 3 4 $ 2,711.94 3 0 $ 2,589.84 2 0 $ 3,516.57 6 4 $ 2,084.09 5 0 $ 2,131.82 4 0 $ 1,150.43 6 7 $ 1,630.16 7 0 96 97 98 99 100 F M M M M 1 0 0 0 0 75 83 68 75 60 3 7 9 7 5 127 140 79 101 14 $ 5,041.93 $ 8,118.92 $ 10,955.29 $ 5,363.25 $ 6,572.60 $ $ $ $ $ 3,645.46 1,730.79 5,662.61 3,409.08 3,892.79 1 5 8 5 6 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 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 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 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 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 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 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 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 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 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 96 97 98 99 100 101 102 103 104 105 106 107 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 Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan Panama Papua New Guinea Paraguay Peru 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 5 6 47 275 187 4 16 112 27 112 32 52 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 5 6 38 162 112 4 14 84 21 79 27 42 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 78 77 68 49 50 78 71 65 74 59 70 69 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