Six Sigma (Process Capability)

profilerunningman1106
six_sigma_analysis_2.xlsx
Home>Human Resource Management homework help>Six Sigma (Process Capability)

Lunch and Dinner Analysis

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.5299373285
R Square 0.2808335722
Adjusted R Square 0.268434151
Standard Error 1.6441160815
Observations 60
ANOVA
df SS MS F Significance F
Regression 1 61.2227124426 61.2227124426 22.6489259712 0.000013343
Residual 58 156.7808259954 2.7031176896
Total 59 218.003538438
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 6.7480168598 0.5059706575 13.3367750881 2.56587465470205E-19 5.7352065565 7.7608271632 5.7352065565 7.7608271632
X Variable 1 -0.1349186728 0.0283496861 -4.7590887753 0.000013343 -0.1916667346 -0.078170611 -0.1916667346 -0.078170611

Lunch Analysis

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9334331755
R Square 0.8712974932
Adjusted R Square 0.8667009751
Standard Error 0.816297683
Observations 30
ANOVA
df SS MS F Significance F
Regression 1 126.3090932615 126.3090932615 189.5559800041 0
Residual 28 18.6575734052 0.6663419073
Total 29 144.9666666667
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 9.6967973824 0.3700569308 26.2035286317 3.05980218960419E-21 8.9387701325 10.4548246324 8.9387701325 10.4548246324
X Variable 1 -0.3020954076 0.0219419579 -13.7679330331 0 -0.3470414704 -0.2571493449 -0.3470414704 -0.2571493449

Dinner Analysis

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.0412757939
R Square 0.0017036912
Adjusted R Square -0.0339497484
Standard Error 1.4591572749
Observations 30
ANOVA
df SS MS F Significance F
Regression 1 0.1017404483 0.1017404483 0.0477847631 0.8285492907
Residual 28 59.6159186823 2.1291399529
Total 29 59.7176591306
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 4.2137478559 0.6214179185 6.780859918 0.0000002301 2.9408309705 5.4866647413 2.9408309705 5.4866647413
X Variable 1 -0.0072338554 0.0330921593 -0.2185972624 0.8285492907 -0.0750200699 0.060552359 -0.0750200699 0.060552359

Raw Data

Time of Day Wait Time (minutes) Customer Satisfaction (1-10)
Lunch 9.5548 7 -0.5299373285
Lunch 21.4950 3
Lunch 26.3915 1
Lunch 11.7057 6
Lunch 15.5191 5
Lunch 28.7761 1
Lunch 27.7146 1
Lunch 8.5575 7
Lunch 8.9540 8
Lunch 18.0349 4
Lunch 4.0550 9
Lunch 20.5527 4
Lunch 8.2985 8
Lunch 23.3592 3
Lunch 14.4198 6
Lunch 18.0643 3
Lunch 11.9445 6
Lunch 11.4930 7
Lunch 14.1029 4
Lunch 12.5650 6
Lunch 15.8737 5
Lunch 17.7516 4
Lunch 13.4854 7
Lunch 13.5948 6
Lunch 7.1309 5
Lunch 5.4951 8
Lunch 25.4996 2
Lunch 9.6127 7
Lunch 12.8767 5
Lunch 26.2330 3
Dinner 18.8415 5
Dinner 16.9362 3
Dinner 5.1428 5 -0.0412757939
Dinner 21.6323 3
Dinner 2.0000 4
Dinner 16.4363 5
Dinner 22.7496 6
Dinner 19.4474 1
Dinner 19.4078 4
Dinner 12.4674 2
Dinner 13.6108 3
Dinner 16.0315 6
Dinner 26.4012 5
Dinner 11.1324 2
Dinner 29.9518 6
Dinner 8.3968 3
Dinner 26.1407 5
Dinner 5.3498 3
Dinner 6.7547 5
Dinner 18.9429 4
Dinner 19.3040 3
Dinner 2.0946 6
Dinner 19.7982 4
Dinner 14.4754 5
Dinner 19.3599 3
Dinner 26.0793 4
Dinner 6.9378 7
Dinner 29.2652 5
Dinner 25.4606 2
Dinner 28.4090 3

Sheet2

mR Current Sandwich Prep

mR Current Sandwich Prep

Range 0.21889999999999987 0.10111772014536169 5.6194867028038331E-2 8.389258717339998E-2 4.1902658527045E-2 7.5322658527045006E-2 4.2959999999999887E-2 6.706000000000012E-2 4.4010000000000105E-2 7.6410715952609953E-2 2.1510715952610004E-2 7.3690000000000033E-2 3.4997753867634041E-2 7.2207753867634006E-2 3.4440000000000026E-2 5.4459999999999953E-2 1.7679999999999918E-2 2.6685199268566828E-2 6.6346297785314645E-2 UCL

UCL

0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 +2 Sigma 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 +1 Sigma 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.111 78874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 Average

CL

6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.36731014 78697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 -1 Sigma 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 -2 Sigma 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Period

Range

X Current Sandwich Prep

X Current Sandwich Prep

Current Sandwich Prep 1.6433500000000001 1.86225 1.7611322798546383 1.7049374128265999 1.7888299999999999 1.7469273414729549 1.8222499999999999 1.77929 1.7122299999999999 1.75624 1.6798292840473901 1.7013400000000001 1.7750300000000001 1.7400322461323661 1.8122400000000001 1.7778 1.7233400000000001 1.74102 1.7143348007314332 1.7806810985167478 UCL

UCL

1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 +2 Sigma 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 +1 Sigm a 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 Average

CL

1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 -1 Sigma 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 -2 Sigma 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 LCL

LCL

1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698

Period

Current Sandwich Prep

Current Sandwich Prep

Current Sandwich Prep UCL +2 Sigma +1 Sigma Average -1 Sigma -2 Sigma LCL LastCell Range UCL +2 Sigma +1 Sigma Average -1 Sigma -2 Sigma LCL
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 0 0.0637
1.6434 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.64335 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.8623 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.86225 0.2189 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7611 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7611322799 0.1011 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7049 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7049374128 0.0562 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7888 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.78883 0.0839 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7469 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7469273415 0.0419 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.8223 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.82225 0.0753 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7793 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.77929 0.0430 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7122 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.71223 0.0671 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7562 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.75624 0.0440 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.6798 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.679829284 0.0764 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7013 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.70134 0.0215 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7750 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.77503 0.0737 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7400 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7400322461 0.0350 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.8122 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.81224 0.0722 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7778 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7778 0.0344 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7233 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.72334 0.0545 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7410 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.74102 0.0177 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7143 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7143348007 0.0267 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.7807 1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.0663 0.2080 0.1599 0.1118 0.0637 0.0156 0.0000 0.0000
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0
1.9205 1.8641 1.8076 1.7512 1.6947 1.6382 1.5818 1.7806810985 0.2080200225 0.1599043822 0.1117887418 0.0637 0.0155574611 0 0

mR Current Sandwich Prep

Range 0.21889999999999987 0.10111772014536169 5.6194867028038331E-2 8.389258717339998E-2 4.1902658527045E-2 7.5322658527045006E-2 4.2959999999999887E-2 6.706000000000012E-2 4.4010000000000105E-2 7.6410715952609953E-2 2.1510715952610004E-2 7.3690000000000033E-2 3.4997753867634041E-2 7.2207753867634006E-2 3.4440000000000026E-2 5.4459999999999953E-2 1.7679999999999918E-2 2.6685199268566828E-2 6.6346297785314645E-2 UCL

UCL

0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 0.20802002253090593 +2 Sigma 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 0.15990438218016989 +1 Sigma 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.111 78874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 0.11178874182943388 Average

CL

6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.367310 1478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 6.3673101478697869E-2 -1 Sigma 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 1.5557461127961851E-2 -2 Sigma 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Period

Range

X Current Sandwich Prep

Current Sandwich Prep 1.6433500000000001 1.86225 1.7611322798546383 1.7049374128265999 1.7888299999999999 1.7469273414729549 1.8222499999999999 1.77929 1.7122299999999999 1.75624 1.6798292840473901 1.7013400000000001 1.7750300000000001 1.7400322461323661 1.8122400000000001 1.7778 1.7233400000000001 1.74102 1.7143348007314332 1.7806810985167478 UCL

UCL

1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 1.9205246731124426 +2 Sigma 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 1.8640678564679971 +1 S igma 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 1.8076110398235516 Average

CL

1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 1.7511542231791062 -1 Sigma 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 1.6946974065346607 -2 Sigma 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 1.6382405898902153 LCL

LCL

1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698 1.5817837732457698

Period

Current Sandwich Prep

Current Process Prep

Current Sandwich Prep
Times (in minutes)
1.6434
1.8623
1.7611
1.7049
1.7888
1.7469
1.8223
1.7793
1.7122
1.7562
1.6798
1.7013
1.7750
1.7400
1.8122
1.7778
1.7233
1.7410
1.7143
1.7807

mR Revised Process Prep

mR Revised Process Prep

Range 5.2788099657644638E-2 0.1069230000000001 7.8651843052690573E-2 1.417184305269048E-2 4.4685644689961723E-2 4.3729461693919891E-3 6.2375757864792103E-3 4.9891217788739839E-2 7.804772324413678E-3 0.11008617115727737 0.14092757154160984 1.9182428458390355E-2 3.5621968169150531E-2 5.4488031830849604E-2 3.2229999999999981E-2 5.2229999999999999E-2 1.0000000000000009E-2 0.10817870379697214 8.2610546448621314E-2 1.2237877903360506E-2 UCL

UCL

0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 0.16715936150264363 +2 Sigma 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 0.12849491169889982 +1 Sigma 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 8.9830461895156005E-2 Average

CL

5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 5.1166012091412194E-2 -1 Sigma 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 1.2501562287668383E-2 -2 Sigma 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Period

Range

X Revised Process Prep

X Revised Process Prep

Revised Process Prep 1.5364349003423554 1.5892230000000001 1.4823 1.5609518430526905 1.54678 1.5020943553100383 1.5064673014794303 1.5002297256929511 1.5501209434816909 1.5423161711572773 1.4322299999999999 1.5731575715416097 1.5923400000000001 1.5567180318308496 1.50223 1.5344599999999999 1.4822299999999999 1.4922299999999999 1.6004087037969721 1.5177981573483508 1.5300360352517113 UCL

UCL

1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661 376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 1.6661376274148676 +2 Sigma 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 1.6207704300271486 +1 Sigma 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 1.5754032326394298 Average

CL

1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 1.5300360352517111 -1 Sigma 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 1.4846688378639923 -2 Sigma 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 1.4393016404762735 LCL

LCL

1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545 1.3939344430885545

Period

Revised Process Prep

Revised Process Prep

Revised Process Prep UCL +2 Sigma +1 Sigma Average -1 Sigma -2 Sigma LCL LastCell Range UCL +2 Sigma +1 Sigma Average -1 Sigma -2 Sigma LCL
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 0 0.0512
1.5364 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5364349003 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5892 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.589223 0.0528 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.4823 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.4823 0.1069 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5610 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5609518431 0.0787 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5468 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.54678 0.0142 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5021 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5020943553 0.0447 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5065 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5064673015 0.0044 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5002 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5002297257 0.0062 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5501 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5501209435 0.0499 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5423 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5423161712 0.0078 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.4322 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.43223 0.1101 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5732 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5731575715 0.1409 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5923 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.59234 0.0192 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5567 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5567180318 0.0356 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5022 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.50223 0.0545 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5345 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.53446 0.0322 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.4822 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.48223 0.0522 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.4922 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.49223 0.0100 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.6004 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.6004087038 0.1082 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5178 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5177981573 0.0826 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.5300 1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.0122 0.1672 0.1285 0.0898 0.0512 0.0125 0.0000 0.0000
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0
1.6661 1.6208 1.5754 1.5300 1.4847 1.4393 1.3939 1.5300360353 0.1671593615 0.1284949117 0.0898304619 0.0512 0.0125015623 0 0