Using the data provided what is the average percentage of infections? (2 marks)
Do the following:
Construct the most appropriate control chart to use for this data,
Compute the upper and lower control limits,
Plot the data on a control chart,
and
Determine if the process is in statistical control. (10 marks)
3. Based on your analysis, what action, if any, should management take? (2 marks)
Here are some data related to the EXCEL file provided to you attached here:
Hide Assignment Information
Instructions
The University Health Network (UHN) has grown out of a series of mergers between Toronto hospitals, and has adjusted and change to accommodate the growing and changing patient community in and around the Greater Toronto Area (GTA).
UHN monitors and evaluates healthcare providers according to strict standards and guidelines. Improvement in the quality of care is a principal concern. Hospitals are required to identify and monitor important quality indicators that affect patient care and establish “thresholds for evaluation” (TFEs), which are levels at which special investigation of problems should occur. TFEs provide a means of focusing attention on non-random errors (that is, special cause of variation). A logical way to set TFEs is through control charts.
Suppose that UHN collects monthly data on the number of infections after surgery. This data is provided in the attached spreadsheet. Hospital administrators are concerned about whether the high percentages of infections (such as 1.76% in month 12) are caused by factors other than randomness.