INPUTS of Question 5 Sample Sample Mean Range Part b Sample Day 1 2 3 4 5 6 7 8 9 10 Time 1 27 22 16 35 21 17 25 15 31 28 Time 2 18 25 15 27 33 15 21 38 26 23 Time 3 20 31 22 16 45 22 26 23 24 29 Time 4 23 40 19 20 12 20 33 25 35 20 Time 5 19 17 23 24 22 30 19 31 32 27 Process Capability Ratio Upper limit = Lower limit = Standard deviation = #DIV/0! calculation for standard deviation to be used in Part b - do NOT delete Co = Parta Mean Control Chart UCL 34.003 given LCL 15.077 given Range Control Chart UCL 34.686 given LCL O given Questions 5 (12 points): Metropolitan General Hospital is a city-owned and operated public hospital. Its emergency room is often crowded and the staff is overworked. One of the key quality attributes administrators focus on is patient waiting time. Hospital administration wants to monitor patient waiting time using statistical process control charts. At different times of the day over a period of 10 days, patient waiting times were recorded with the results shown in worksheet Q5 a) Construct both the Mean and Range control charts for the sample data provided. And comment on if the process appears to be in control or not. The city has established a requirement that emergency room patients have a waiting time of 25 minutes + 5 minutes. b) Calculate the capability ratio for this process on using the standard deviation provided in the worksheet. And comment on if the emergency room capable of meeting this requirement with its current process