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

After you eliminated the assignable causes associated with the out-of-control points and implemented improvement solutions, you again measured 4 patients per day over a period of 25 days. The waiting times in minutes for the newly improved process are reported 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. What can you conclude from the new process, as compared with the previous one?

Day	1	2	3	4	Day	1	2	3	4
1	8	15	12	9	14	17	14	16	10
2	15	18	11	11	15	10	11	8	7
3	15	7	10	10	16	17	12	10	18
4	15	20	17	13	17	11	7	9	15
5	11	13	9	8	18	20	10	18	10
6	18	15	14	10	19	7	9	12	8
7	15	6	8	10	20	10	14	15	20
8	12	21	10	15	21	6	11	8	9
9	11	8	12	8	22	16	18	17	13
10	12	9	11	17	23	8	6	9	10
11	5	9	12	11	24	13	17	9	13
12	16	11	19	10	25	14	8	9	11
13	7	14	7	16