Hospitals are required to identify and monitor important quality indicators and establish thresholds for evaluation, which are levels at which special investigations should occur.

Eckhardt Hospital collecting data on the number of infections that occurred for samples of 200 surgeries each month over a 3 year period

1.Select the right type of control chart for this data, and construct the chart with proper control limits

2.Using the criteria for assessing patterns in control charts, determine if this process is in control

3.Provide the hospital with 3 criteria they can use as a threshold for evaluation moving forward. (these should be easy to see visually from the control chart)

Show work in excel