2 vi X fx =IF(A2=ROUND($J$6,2),$J$8, IF(A2=ROUND($J$7,2),$1$8,0)) A B D E F G H Bins Data Frequency Probability Mass Function Cumulative Distribution Function Six Sigma Units Tolerance Limits 1.1 3.42 0 7.90126E-09 7.52175E-10 UTL (Upper Tolerance Limit) 1.55 -0.7 1.67 3.77141E-07 4.01773E-08 LTL (Lower Tolerance Limit) 3.43 0.3 1.98 0 1.13744E-05 1.3743E-06 H (Arithmetic Mean) 2.468 0.1 1.66 0 0.000216755 3.02059E-05 o (Standard Deviation of A Sample) 0.590347528 0.5 1.64 O 0.002609914 0.000428604 u + 60 (Upper Six-Siggma-Limit) 6.010085169 0.9 2.06 0 0.019856399 0.003952947 H - 60 (Lower Six-Sigma-Limit) -1.074085169 1.3 2.46 0 0.0954534 0.023936411 Maximum Vertical Axis 14 1.7 2.36 6 0.289933905 0.096641443 CPK (Process Capability Index) -0.543182873 2.1 1.82 12 0.556446354 0.266523452 CP (Max possible process capability) 2.5 2.95 9 0.674783244 0.521614225 o o o o o o 0 0 0 0 0 0 0 0 0 0 0 0 0 o o o o o o o o o o O o O O O O O O O 2.9 2.32 6 0.517037415 0.767846237 3.3 2.94 14 0.250320459 0.920632575 3.7 3.24 0.076575072 0.981551699 4.1 3.23 0 0.01480114 0.997149262 4.5 3.38 0 0.001807672 0.999711328 4.9 2.10 0 0.000139496 0.999981024 5.3 2.71 0 6.80172E-06 0.999999195 5.7 1.75 2.09553E-07 0.999999978 6.1 2.52 o o O 4.07929E-09 1 3.13 2.26 3.00 2.45 3.43 3.15 2.02 3.07 2.74 3.01G2 v ! X V fx =IF(A2=$1$2,$1$8,IF(A2=$1$3,$1$8,0)) A B C D E G H Bins Data Frequency Probability Mass Function Cumulative Distribution Function Six Sigma Units Tolerance Limits IN -1.1 3.42 7.90126E-09 7.52175E-10 UTL (Upper Tolerance Limit) 1.55 -0.7 1.67 3.77141E-07 4.01773E-08 LTL (Lower Tolerance Limit) 3.43 -0.3 1.98 1.13744E-05 1.3743E-06 H (Arithmetic Mean) 2.468 0.1 1.66 0.000216755 3.02059E-05 (Standard Deviation of A Sample) 0.590347528 0.5 1.64 0.002609914 0.000428604 u + 60 (Upper Six-Siggma-Limit) 6.010085169 0.9 2.06 0 0.019856399 0.003952947 H - 60 (Lower Six-Sigma-Limit) -1.074085169 1.3 2.46 0.0954534 0.023936411 Maximum Vertical Axis 14 1.7 2.36 0.289933905 0.096641443 CPK (Process Capability Index) -0.543182873 2.1 1.82 12 0.556446354 0.266523452 CP (Max possible process capability) 2.5 2.95 0.674783244 0.521614225 o o o o o o o o o o o o o o o o o o C 2.9 2.32 6 0.517037415 0.767846237 13 3.3 2.94 14 0.250320459 0.920632575 14 3.7 3.24 3 0.076575072 0.981551699 15 4.1 3.23 0.01480114 0.997149262 16 4.5 3.38 0.001807672 0.999711328 17 4.9 2.10 0.000139496 0.999981024 18 5.3 2.71 ooo ooo 6.80172E-06 0.999999195 19 5.7 1.75 2.09553E-07 0.999999978 20 6.1 2.52 4.07929E-09 1 3.13 2.26 3.00Bev # Min Bev # Min Bev # Min Bev # Min Bev # Min Bev 1 3.42 Bev 11 2.32 Bev 21 2.26 Bev 31 2.73 Bev 41 1.74 Bev 2 1.67 Bev 12 2.94 Bev 22 3.00 Bev 32 2.80 Bev 42 2.04 Bev 3 1.98 Bev 13 3.24 Bev 23 2.45 Bev 33 3.08 Bev 43 1.85 Bev 4 1.66 Bev 14 3.23 Bev 24 3.43 Bev 34 1.60 Bev 44 1.69 Bev 5 1.64 Bev 15 3.38 Bev 25 3.15 Bev 35 3.19 Bev 45 2.66 Bev 6 2.06 Bev 16 2.10 Bev 26 2.02 Bev 36 2.25 Bev 46 3.23 Bev 7 2.46 Bev 17 2.71 Bev 27 3.07 Bev 37 2.32 Bev 47 3.16 Bev 8 2.36 Bev 18 1.75 Bev 28 2.74 Bev 38 3.00 Bev 48 1.78 Bev 9 1.82 Bev 19 2.52 Bev 29 3.01 Bev 39 1.96 Bev 49 2.14 Bev 10 2.95 Bev 20 3.13 Bev 30 1.55 Bev 40 1.84 Bev 50 2.32