question archive A team of experts are trying to assess the service quality in a developed country
A team of experts are trying to assess the service quality in a developed country
Subject:ManagementPrice: Bought3
A team of experts are trying to assess the service quality in a developed country. They have
identified that patient readmissions as an indicator of bad service quality. To simplify their analysis, they have collected data on patient admissions and readmissions in three of the most common health conditions for 1 year (from Jan 1st to Dec 31st of 2013). Data is attached
For the rest of this part of the assignment we will refer to the ratio of total readmissions to
admissions as the readmission's ratio.
Q1 - Using the sheet "Readmissions Data" in the file "readmissionData.xls"
, calculate the overall average readmissions ratio for the period from January 1 to December 31,
2013 (in the following, we will refer to this number as p bar)
Q2 - For every day in this period, calculate the readmissions ratio as well as
upper and lower control limits above and below p bar.
What was the Upper Control Limit (UCL) on April 23rd, 2013? Hint: In this case
UCL depends on the total admissions for the day.
Q3- How many days in this period were "out of control" in a statistical sense, i.e.,
had a readmissions ratio higher than the upper control limit for the day?
Q4 - For the out of control days, what is the most prevalent health condition
which patients readmit? What is the least prevalent health condition on the out of
control days?
