Healthcare Data Analytics N526

Descriptive Statistics Using Excel Central Tendency

  • Calculate the mean, median, and mode: LOS and Total Charge.
  • Sort the charge values in ascending order.
  • Calculate the mean, median, and mode of the Total Charge excluding the maximum value.
  • Did the mean, median, and mode change more? Why?
  • Repeat that exercise for LOS. Healthcare Data Analytics N526
  • What do you think is the best statistic to describe the typical: LOS or Total Charge o Admission source Descriptive Statistics Using Excel Spread
  • Calculate the sample variance and range for LOS and Total Charge.
  • Note: Use the var.s function to calculate the variance. This function calculates the sample variance.
  • Sort the charge values in ascending order.
  • Calculate the variance and range charge excluding the maximum value.
  • Did the variance and range mean or median change more? Why?
  • Repeat that exercise for LOS.

One Sample T-Test (two-tailed)

  • Test the hypothesis that the sample mean LOS for MS-DRG 291 is different from the national standard. Obtain the national Medicare standard for LOS from the information provided below. **Be sure to state the null and alternative hypotheses and set the alpha prior to performing the test.

Total hospital days for HF are estimated at 6.5 million annually. Although the average length of stay has decreased over the last decade to 6.3 days, the 30-day readmission rate has increased to 20% and is roughly 50% at 6 months .The average MS-DRG (291, 292, and 293) reimbursement is $5,759 for the acute care facility.

Two Sample T-Test Two Tail

  • Test the hypothesis that charges for patients with MS-DRG 291 are different for men and women. Assume equal variances. Healthcare Data Analytics N526 **Be sure to state the null and alternative hypotheses and set the alpha prior to performing the test.

ANOVA

The basic principle of the IPPS payment system is that the levels (no CC/CC/MCC) of a MS-DRG family have 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.

  • Can you conclude which MS-DRGs have significantly different average charges?