六西格瑪計算表.xls.xls

Worksheet For Calculating Sigma Performance Continuous Data Calculatiung Sigma Calculating Sigma Performance Enter Xbar6 7 S0 1533 USL6 8 LSL sigma 0 65sigma 0 652316 0 742901 0 257099 N A N A N A 0 257099 0 742901 74 2901 702009 O Worksheet For Calculating Process SigmaWorksheet For Calculating Process Sigma Continuous Data Long TermContinuous Data Long Term 2 Determine Area 1 Find Z1 Look up Z1 in Normal Table Area 1 1 Look UpArea 1 1 Norm Dist Z1 1 4 Determine Total Area 5 Yield 1 Total Area 6 Process Sigma Comes From Table Look Up Of Yield Total Area Area 1 Area 2 Yield 1 Total Area 1 SigmaST Look Up Value in Sigma Table Z1 Normal Table Look Up for Z1Norm Dist USL x s Z1 x 100 3 Skip this step if there is no LSL Area 2 2 Determine Area 2 Find Z2 Look up Z2 in Normal Table Area 2 Look Up LSL x s Z2 Z2 Normal Table Look Up for Z2Norm Dist nX value nX s value nUSL Shade Area To The Right nLSL Shade Area To The Left s x x s s USL 22 Area 1 Area 2 1018 LSL 8 1 Label The Normal Curve With The Following Example 0 65 702009 O Worksheet For Calculating Process SigmaWorksheet For Calculating Process Sigma Continuous Data Long TermContinuous Data Long Term 2 Determine Area 1 Find Z1 Look up Z1 in Normal Table Area 1 1 Look UpArea 1 1 Norm Dist Z1 1 4 Determine Total Area 5 Yield 1 Total Area 6 Process Sigma Comes From Table Look Up Of Yield Total Area Area 1 Area 2 Yield 1 Total Area 1 SigmaST Look Up Value in Sigma Table Z1 Normal Table Look Up for Z1Norm Dist USL x s Z1 x 100 3 Skip this step if there is no LSL Area 2 2 Determine Area 2 Find Z2 Look up Z2 in Normal Table Area 2 Look Up LSL x s Z2 Z2 Normal Table Look Up for Z2Norm Dist nX value nX s value nUSL Shade Area To The Right nLSL Shade Area To The Left s x x s s USL 22 Area 1 Area 2 1018 LSL 8 1 Label The Normal Curve With The Following Example Delete if no USL Delete if no LSL Worksheet For Calculating Sigma Performance Continuous Data Calculating Sigma Performance DPMO Method Page 4 Worksheet For Calculating Sigma Performance enter 1Number Of Units Processed N 500 2Total Number Of Defects MadeD 57 Include Defects Made And Later Fixed 3Number Of Defect OpportunitiesO 3 Per Unit 4So