Statistical Process Control using Minitab

profileClay1203
delivery_process_spc.xlsx

Sheet1

Time to prepare pizza and place in oven (in minutes)
Sample 1 Sample 2 Sample 3 Sample 4 X-Bar Range Sigma
5 3 5 3 4 2 1.1547005384
6 3 5 3 4.25 3 1.5
5 4 4 3 4 2 0.8164965809
7 3 4 3 4.25 4 1.8929694486
5 5 5 3 4.5 2 1
8 4 3 2 4.25 6 2.6299556397
3 7 4 2 4 5 2.1602468995
3 4 6 4 4.25 3 1.2583057392
4 5 6 4 4.75 2 0.9574271078
5 4 7 3 4.75 4 1.7078251277
X Bar = 43/10 = 4.3 s Bar = 15.08/10 = 1.508
Time required for pizza to be prepared, cooked, and removed from oven (in minutes)
Sample 1 Sample 2 Sample 3 Sample 4 X-Bar Range Sigma
13 11 17 12 13.25 5 2.6299556397
15 11 20 14 15 6 3.7416573868
11 14 20 16 15.25 9 3.7749172176
17 16 21 16 17.5 5 2.3804761428
11 15 23 17 16.5 12 5
14 15 24 17 17.5 10 4.5092497528
15 14 24 21 18.5 10 4.7958315233
12 18 26 19 18.75 14 5.737304826
20 17 23 22 20.5 6 2.6457513111
16 12 21 22 17.75 9 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)
Sample 1 Sample 2 Sample 3 Sample 4 X-Bar Range Sigma
20 21 19 23 20.75 4 1.7078251277
18 18 18 20 18.5 2 1
18 21 19 20 19.5 3 1.2909944487
17 20 19 21 19.25 4 1.7078251277
18 16 19 24 19.25 8 3.4034296428
16 16 18 20 17.5 4 1.9148542155
20 17 19 19 18.75 3 1.2583057392
19 18 18 19 18.5 1 0.5773502692
19 17 17 20 18.25 3 1.5
20 19 18 21 19.5 3 1.2909944487
X Bar = 189.75/10 = 18.975 s Bar = 15.67/10 = 1.567
Delivery time (in minutes)
Sample 1 Sample 2 Sample 3 Sample 4 X-Bar Range Sigma
31 36 60 19 36.5 41 17.2143351116
29 35 60 22 36.5 38 16.5428735916
29 36 58 23 36.5 35 15.2861593171
28 46 70 26 42.5 44 20.4205778567
31 45 63 28 41.75 35 15.9869738642
31 50 61 29 42.75 32 15.4137384607
32 55 45 28 40 27 12.3558353286
30 54 40 29 38.25 25 11.6153633894
34 55 36 30 38.75 25 11.1168040971
33 60 47 29 42.25 31 14.1273965519
X Bar = 395.75/10 = 39.575 s Bar = 150.09/10 = 15.009

Sheet2

Sheet3