Question: Please type all answers and attach control charts ONLY without data sheets. 1. Patients complaints about long wait times have historically been a major problem
Please type all answers and attach control charts ONLY without data sheets.
1. Patients complaints about long wait times have historically been a major problem in an outpatient center. As an administrator, you decided to use SPC tools to reduce wait times. Every day, you measured wait times of 4 randomly-selected patients over a period of 25 days. Measurements in minutes are shown in the following table. Use MS Excel to construct appropriate control charts and specify the control limits including 1-sigma and 2-sigma limits. Circle out-of-control points based on the Detection Rules.
| Day | 1 | 2 | 3 | 4 | Day | 1 | 2 | 3 | 4 |
| 1 | 8 | 15 | 12 | 9 | 14 | 17 | 14 | 16 | 10 |
| 2 | 15 | 7 | 11 | 22 | 15 | 24 | 11 | 8 | 19 |
| 3 | 15 | 7 | 10 | 10 | 16 | 17 | 12 | 10 | 18 |
| 4 | 7 | 28 | 17 | 13 | 17 | 25 | 7 | 9 | 15 |
| 5 | 11 | 13 | 9 | 8 | 18 | 20 | 10 | 18 | 10 |
| 6 | 22 | 15 | 35 | 10 | 19 | 30 | 14 | 17 | 15 |
| 7 | 7 | 6 | 8 | 10 | 20 | 10 | 14 | 15 | 20 |
| 8 | 28 | 21 | 10 | 24 | 21 | 20 | 11 | 8 | 17 |
| 9 | 11 | 8 | 12 | 8 | 22 | 24 | 7 | 6 | 10 |
| 10 | 1 | 7 | 6 | 17 | 23 | 15 | 7 | 12 | 13 |
| 11 | 5 | 9 | 12 | 11 | 24 | 7 | 2 | 15 | 13 |
| 12 | 16 | 25 | 31 | 21 | 25 | 14 | 8 | 9 | 17 |
| 13 | 7 | 14 | 7 | 16 |
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
