Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE ANSWER WITH EXCEL FORMULAS IN EXCEL FORMAT A. Suppose the 60 hospital discharges on the Hospital Charges worksheet represent a random sample of all
PLEASE ANSWER WITH EXCEL FORMULAS IN EXCEL FORMAT
| A. Suppose the 60 hospital discharges on the Hospital Charges worksheet represent a random sample of all Medicare-eligible persons discharged from a specific hospital. |
| 3. Calculate the variance and standard deviation of Age, LOS, and Charges by using the =VAR() and STDEV functions. | |||||||||||||
| 4. Test the hypothesis at the 95 percent level of confidence that average Charges for the population is $6,000 (H0: C=$6,000), against the alternative hypothesis that average Charges is not $6,000 (H1: C$6,000), and state your conclusion. |
| IDI57A1A12:I50 | Sex | Age | LOS | DRG | Charges | Medicare | Diag | ICD-9 |
| 1 | F | 46 | 4 | 294 | $ 2,426.48 | $ 2,003.62 | 2 | 0 |
| 2 | F | 87 | 8 | 139 | $ 6,815.61 | $ 1,072.17 | 4 | 4 |
| 3 | F | 70 | 10 | 34 | $ 7,596.68 | $ 4,096.98 | 6 | 0 |
| 4 | M | 72 | 5 | 140 | $ 6,450.77 | $ 1,710.79 | 5 | 0 |
| 5 | F | 82 | 3 | 141 | $ 3,542.79 | $ 1,914.90 | 3 | 7 |
| 6 | F | 85 | 2 | 15 | $ 2,590.86 | $ 2,601.14 | 5 | 4 |
| 7 | F | 73 | 5 | 294 | $ 5,082.83 | $ 2,035.31 | 7 | 2 |
| 8 | M | 65 | 6 | 241 | $ 3,580.55 | $ 2,320.42 | 6 | 0 |
| 9 | M | 73 | 6 | 335 | $ 11,045.79 | $ 4,184.26 | 1 | 0 |
| 10 | F | 94 | 14 | 148 | $ 19,708.11 | $12,158.49 | 4 | 0 |
| 11 | F | 94 | 11 | 89 | $ 8,953.38 | $ 4,345.84 | 4 | 0 |
| 12 | M | 79 | 5 | 127 | $ 7,000.21 | $ 3,993.48 | 5 | 0 |
| 13 | M | 82 | 6 | 89 | $ 5,330.24 | $ 3,408.07 | 4 | 0 |
| 14 | F | 76 | 3 | 122 | $ 6,864.63 | $ 3,637.35 | 5 | 4 |
| 15 | M | 72 | 3 | 336 | $ 4,318.13 | $ 2,676.01 | 2 | 0 |
| 16 | F | 91 | 7 | 321 | $ 6,424.30 | $ 1,510.20 | 3 | 0 |
| 17 | F | 90 | 6 | 174 | $ 5,184.53 | $ 3,642.44 | 6 | 5 |
| 18 | F | 83 | 3 | 143 | $ 1,871.78 | $ 1,167.65 | 6 | 0 |
| 19 | F | 82 | 11 | 358 | $ 11,179.97 | $ 3,432.13 | 9 | 6 |
| 20 | F | 49 | 2 | 140 | $ 3,405.38 | $ 1,710.79 | 1 | 0 |
| 21 | F | 88 | 2 | 143 | $ 1,731.73 | $ 1,979.28 | 4 | 7 |
| 22 | F | 75 | 2 | 159 | $ 5,384.92 | $ 3,316.59 | 2 | 0 |
| 23 | M | 81 | 7 | 89 | $ 5,216.91 | $ 3,613.06 | 2 | 4 |
| 24 | F | 76 | 4 | 294 | $ 2,489.65 | $ 2,201.93 | 3 | 0 |
| 25 | F | 85 | 10 | 473 | $ 8,244.25 | $12,772.75 | 4 | 0 |
| 26 | F | 84 | 6 | 128 | $ 3,548.05 | $ 2,163.29 | 8 | 4 |
| 27 | F | 77 | 3 | 15 | $ 4,713.26 | $ 1,801.73 | 4 | 0 |
| 28 | F | 94 | 6 | 121 | $ 5,804.21 | $ 5,282.36 | 5 | 7 |
| 29 | F | 66 | 6 | 128 | $ 2,945.22 | $ 2,849.72 | 2 | 0 |
| 30 | M | 72 | 1 | 140 | $ 1,035.75 | $ 1,685.62 | 5 | 4 |
| 31 | M | 78 | 3 | 209 | $ 17,005.45 | $ 7,534.44 | 1 | 7 |
| 32 | F | 86 | 3 | 143 | $ 4,637.96 | $ 1,447.84 | 5 | 0 |
| 33 | F | 70 | 5 | 209 | $ 17,480.97 | $ 7,566.98 | 5 | 0 |
| 34 | M | 72 | 5 | 96 | $ 5,029.09 | $ 3,306.80 | 8 | 4 |
| 35 | M | 91 | 3 | 144 | $ 3,078.99 | $ 3,351.64 | 5 | 4 |
| 36 | M | 75 | 2 | 90 | $ 2,146.99 | $ 1,968.05 | 2 | 4 |
| 37 | F | 83 | 6 | 88 | $ 5,482.93 | $ 3,147.39 | 2 | 0 |
| 38 | M | 82 | 1 | 183 | $ 1,078.56 | $ 1,386.42 | 6 | 5 |
| 39 | F | 82 | 10 | 430 | $ 9,931.21 | $ 3,530.00 | 1 | 0 |
| 40 | F | 92 | 2 | 138 | $ 2,451.69 | $ 2,266.56 | 2 | 4 |
| 41 | F | 79 | 2 | 88 | $ 2,834.68 | $ 3,579.24 | 1 | 0 |
| 42 | F | 69 | 2 | 447 | $ 1,547.81 | $ 988.00 | 3 | 0 |
| 43 | F | 76 | 3 | 183 | $ 1,876.70 | $ 1,235.80 | 1 | 0 |
| 44 | M | 73 | 2 | 140 | $ 2,781.28 | $ 1,483.79 | 4 | 0 |
| 45 | F | 83 | 6 | 127 | $ 6,460.59 | $ 3,993.48 | 5 | 0 |
| 46 | F | 80 | 4 | 444 | $ 3,026.42 | $ 1,918.32 | 1 | 6 |
| 47 | F | 76 | 10 | 493 | $ 14,769.92 | $ 5,594.68 | 4 | 5 |
| 48 | F | 77 | 7 | 324 | $ 4,425.44 | $ 1,531.55 | 5 | 5 |
| 49 | F | 85 | 4 | 140 | $ 5,151.52 | $ 1,710.79 | 5 | 0 |
| 50 | F | 70 | 1 | 140 | $ 2,404.39 | $ 735.58 | 1 | 4 |
| 51 | M | 81 | 2 | 140 | $ 5,019.86 | $ 1,730.79 | 2 | 0 |
| 52 | F | 83 | 9 | 138 | $ 10,421.01 | $ 2,384.12 | 5 | 0 |
| 53 | M | 76 | 2 | 269 | $ 4,860.83 | $ 5,688.67 | 4 | 1 |
| 54 | F | 88 | 3 | 140 | $ 2,694.11 | $ 1,564.50 | 2 | 0 |
| 55 | M | 88 | 4 | 208 | $ 2,421.63 | $ 1,346.94 | 2 | 0 |
| 56 | F | 89 | 2 | 15 | $ 3,311.66 | $ 2,065.49 | 3 | 0 |
| 57 | M | 39 | 1 | 434 | $ 1,596.91 | $ 392.00 | 5 | 3 |
| 58 | F | 89 | 5 | 88 | $ 5,399.67 | $ 3,048.91 | 4 | 4 |
| 59 | M | 80 | 12 | 78 | $ 17,605.59 | $ 4,432.93 | 9 | 7 |
| 60 | F | 71 | 7 | 89 | $ 11,098.70 | $ 4,256.70 | 3 | 4 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Auditing Cases An Active Learning Approach
Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt
2nd Edition
0130674842, 978-0130674845
