Discussion Post
TopicI:
Descriptive Statistics Using Excel - Central Tendency
o Calculate the mean, median and mode charge.
o Sort the charge values in ascending order.
o Calculate the mean, median and mode charge excluding the maximum value.
o Did the mean, median, and mode change more? Why?
Topic II:
o Calculate the mean, median and mode LOS.
o Sort the LOS values in ascending order.
o Calculate the mean, median and mode LOS excluding the maximum value.
o Did the mean, median, and mode change ? Why?
Topic III:
Descriptive Statistics Using Excel - Spread
o Calculate the variance and range LOS.
o Sort the LOS values in ascending order.
o Calculate the variance and range LOS excluding the maximum value.
o Did the variance and range mean or median change more? Why?
Topic IV:
o Calculate the variance and range charge.
o Sort the charge values in ascending order.
o Calculate the variance and range charge excluding the maximum value.
o Did the variance and range mean or median change more? Why?
Topic V:
One Sample T-Test
o Test the hypothesis that the sample mean LOS for MS-DRG 291 is different from the national standard. Obtain the national Medicare LOS from HCUP.
o Be sure to state the null and alternative hypotheses and set the alpha prior to performing the test.
Topic VI:
Two Sample T-Test
o Test the hypothesis that charges for patients with MS-DRG 291 are different for men and women.
o Be sure to state the null and alternative hypotheses and set the alpha prior to performing the test.
Topic VII:
ANOVA
o The basic principle of the IPPS payment system is that the ‘levels' (no CC/CC/MCC) of a MS-DRG family has different resource intensity and therefore should be paid differently. Use the CHF data to test this hypothesis. Use charge as a measure of resource intensity. Be sure to state the null and alternative hypotheses and set the alpha prior to performing the test.
o Can you conclude which MS-DRGs have significantly different average charges?
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.