Dear experts,
I have been trying to create a control chart in excel but I am not certain if I have chosen the correct control chart. Can someone review my working out and advise if I am doing things correctly?
My data looks at harm caused from an incident to patients during their occupied bed days. I have decided to go for a u chart on the basis that the occupied bed days can vary significantly and the incidents could happen multiple times to a single patient.
I have attempted to plot this out in excel however I am confused as to the numbers I am getting for the u bar, UCL and LCL. They are all small numbers 0.01 etc. Can anyone explain why there are small numbers? Also is it possible to show the data per 1000 occupied bed days?
I have attached the excel spread sheet if anyone would like to view it.
Your help/guidance is much appreciated!
Saif
I have been trying to create a control chart in excel but I am not certain if I have chosen the correct control chart. Can someone review my working out and advise if I am doing things correctly?
My data looks at harm caused from an incident to patients during their occupied bed days. I have decided to go for a u chart on the basis that the occupied bed days can vary significantly and the incidents could happen multiple times to a single patient.
I have attempted to plot this out in excel however I am confused as to the numbers I am getting for the u bar, UCL and LCL. They are all small numbers 0.01 etc. Can anyone explain why there are small numbers? Also is it possible to show the data per 1000 occupied bed days?
I have attached the excel spread sheet if anyone would like to view it.
Your help/guidance is much appreciated!
Saif
Attachments

96.5 KB Views: 164