Accompanying this problem set is an excel file on the first


Accompanying this problem set is an Excel file. On the first tab, are data that represent 50 periods where, for each period, 20 printed circuit boards are inspected for defects, with the number of defect opportunities per board is 4,250. For each period, what is provided is the total number of defects found (among all 20 boards). (20)

Using the data set, develop the dpmo and dpbo control charts using only the first 25 periods of data for the calculations, but plot all 100 data points. (If there are any out-of-control points in the first 25 periods, you don't need to remove them and you donâ€TMt need to recalculate the control limits). Out of all 60, note whether or not you suspect a process shift and, if so, the approximate location.

Period

#Def

1

1

2

2

3

3

4

0

5

0

6

0

7

4

8

4

9

3

10

1

11

0

12

2

13

0

14

2

15

1

16

1

17

4

18

1

19

1

20

2

21

1

22

1

23

1

24

1

25

1

26

2

27

0

28

1

29

2

30

1

31

1

32

0

33

1

34

1

35

2

36

1

37

2

38

2

39

1

40

0

41

2

42

1

43

2

44

2

45

1

46

3

47

1

48

1

49

5

50

0



SHOW ALL WORK

Solution Preview :

Prepared by a verified Expert
Business Management: Accompanying this problem set is an excel file on the first
Reference No:- TGS02923960

Now Priced at $10 (50% Discount)

Recommended (98%)

Rated (4.3/5)