
Supplement to Chapter on DistributionsPresentations
AssignmentsQuestion 1: In this problem we ask you to calculate a case mix index for a hospital from classification of its patients into Diagnostic Related Groupings (DRGs). In Health Administration programs case mix issues arises in multiple courses where severity of patients receiving care in different hospitals are discussed. The case mix index allows the comparison of two hospitals. It is generally calculated as a weighted length of stay across all DRGs see in the hospital. The concept of weighted average was discussed in this section. In a case mix index, the weights are the probability of observing patients in a particular DRG category. Each DRG category is assumed to be mutually exclusive and exhaustive. The number of patients who are admitted for different DRGs are indicated in the attached data file. From these numbers you calculate the probability of each DRG. By multiplying the probability of the DRG by length of stay you get the contribution of each DRG. The case mix index is the sum of the product of probability of each DRG and length of stay within each DRG. The higher the case mix index, the larger the expected length of stay at the hospital. Which hospital has a higher case mix index? Data► Answer► Akhil Anto's Teach One►
Question 2: Download
Hospital Compare Data using the link below. Select flat file
"Complications  Hospital.CSV" Read the data into Excel. For
all hospitals select "Rate of complications for hip/knee replacement
patients". You can do this by using Excel's filter. Calculate the
average rate across all hospitals. Calculate the standard deviation for
the rate across all hospitals. Excel has commands for calculation of
standard deviation and averages, please use these commands. Report the
average rate and the standard deviation of the rate to your instructor
(do not include the data in your submission). Data is also
available through Medicare Compare site: Hospital
Compare► Answer► Question 4: For this question use the file "Complications  Hospital.CSV" in Hospital Compare. Same file was also downloaded for question 2. Plot the relationship between rate of complications for hip/knee replacements and pressure sores. Use scatter plot in Excel. Have the rate of complications as Xaxis and pressure scores as Y axis. Data► Excel Scatter Plots►
