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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!