Question: please help and show excel work The quality controller at a local hospital has collected data on the proportion of rework in the lab (based

please help and show excel work

  1. The quality controller at a local hospital has collected data on the proportion of rework in the lab (based on a sample size of 25). The data collected is as follows:

Proportion of

Rework in

Day

the lab

1

0.048

2

0.083

3

0.047

4

0.046

5

0.090

6

0.046

7

0.034

8

0.060

9

0.097

10

0.070

11

0.045

12

0.036

13

0.045

14

0.057

15

0.078

16

0.082

17

0.041

18

0.032

19

0.072

20

0.053

21

0.041

22

0.007

23

0.039

24

0.055

25

0.048

26

0.054

27

0.064

28

0.079

29

0.055

30

0.046

Construct the necessary control charts using Excel. Show the upper control limits, the lower control limits, and the centerline. Show the calculations on one page and the control charts on the following pages. State whether the processes are in or out of control.

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!