Lab 8.2 - Hip Data Use Hip Data 1. Calculate a column for % Ancillary charge = (departmental charges)/(total charge) 2. Copy % anc for MSDRGs 469 and 470 into adjacent columns (example below): 469 % 470% Anc Anc 80% 87% 76% 81% 72% 93% 87% 89% 72% 90% 92% 85% 87% 91% 3. Calculate 95% confidence intervals for the % anc for both 469 and 470. a. Which confidence interval is wider? b. Why? i. Statistically? ii. Practically? iii. Note: MSDRG 469: Major joint procedures w MCC; MSDRG 470: Major joint procedures no MCC 4. The US average for percent of charges coming from ancillary departments for MSDRG 470 is 86.9%. Formulate the null and alternative hypothesis to test to see if our hospital is statistically different from the US. 5. The US average charge for MSDRG 470 is $36,450. Formulate the null and alternative hypothesis to test to see if our hospital is statistically different from the US. 6. The US average LOS for MSDRG 470 is 3.6 days. Formulate the null and alternative hypothesis to test to see if our hospital is statistically different from the US. Calculate the p-value for this test