Statistical Process Control using Minitab

Can anyone some charts for me using the attached data?

I need X Bar and R chart, P chart, and Cp, Cpk for each of the four processes listed in the attached document.

 

I’ve been having trouble calculating UCL and LCL based on this data so if you need more data please let me know.  

 

I will need this by tomorrow afternoon at the latest.  My project is due tomorrow, Sunday, December 9 2012.  After Sunday afternoon I will have no need for help with this anymore as my project will have already been submitted.

2

>Sheet

1

3 5 3 4 2

4

0053

4

3 5 3

3

5 4 4 3 4 2

4

6

09

7 3 4 3 4.25 4

69

86

5 5 5 3

2 1

8 4 3 2 4.25 6

97

3 7 4 2 4 5

68995

3 4 6 4 4.25 3

57392

4 5 6 4

2

78

5 4 7 3 4.75 4

7825

77

8

Sample 2

X-Bar Range Sigma

12

5 2.6299556397

15 11

15 6

657

68

11 14 20 16

9

76

17 16 21 16

5

4

11 15

17

12 5

14 15 24 17 17.5 10

15 14 24 21

.5

10

52

12 18

14

20 17 23

6

7513111

16 12 21 22

9

Sample 1 Sample 2 Sample 3 Sample 4 X-Bar Range Sigma

20 21 19 23

4

18 18 18 20

2 1

18 21 19 20

3

17 20 19 21

4 1.7078251277

18 16 19 24 19.25 8

296428

16 16 18 20 17.5 4

2155

20 17 19 19 18.75 3 1.2583057392
19 18 18 19 18.5 1

02692

19 17 17 20

3 1.5

20 19 18 21 19.5 3 1.2909944487

Sample 1 Sample 2 Sample 3 Sample 4 X-Bar Range Sigma

31

60 19

41

29 35 60 22 36.5 38

29 36 58 23 36.5 35

28

70 26

44

31 45 63 28

35

31 50 61 29

32 55 45 28 40 27

30 54 40 29

25

34 55 36 30

25

33 60 47 29

31

												Time to prepare pizza and place in oven (in minutes)
		Sample 1				Sample 2	Sample																		3	Sample																		4				X-Bar				Range				Sigma
												5	1.					15			7		8
					6				4.		25		1.5
0.8							16		9	58
1.89					29	44
4.5
	2.6299		55	63
2.1			60			24
	1.258		30
	4.75	0.9574	27		10
1.	70				12
X Bar = 43/10 = 4.3	s Bar = 15.08/10 = 1.	50
Time required for pizza to be prepared, cooked, and removed from oven (in minutes)
Sample 1			Sample 3			Sample 4
13				11									17	13.25
										20					14	3.7	41	38
15.25	3.774917							21
		17.5	2.380	47	61			28
			23	16.5
4.5092497528
										18	4.7958				31	33
	26												19		18.75	5.737304826
		22	20.5	2.6		45
17.75	4.6457866216
X Bar = 170.5/10 = 17.05	s Bar = 39.87/10 = 3.987
Time required for order to be prepared and completed (in minutes)
20.75		1.7078251277
	18.5
	19.5		1.2909944487
	19.25
3.		40	34
1.9148	54
0.577			35
18.25
X Bar = 189.75/10 = 18.975	s Bar = 15.67/10 = 1.567
Delivery time (in minutes)
		36			36.5	17.2143351116
16.5428735916
15.2861593171
46	42.5	20.4205778567
41.75	15.9869738642
42.75		32	15.4137384607
12.3558353286
38.25	11.6153633894
38.75	11.1168040971
42.25	14.1273965519
X Bar = 395.75/10 = 39.575	s Bar = 150.09/10 = 15.009

Sheet2

Sheet3