SigmaCalculator

CalculatiungSigmaCalculatingSigmaPerformanceEnterXbar11.5S1USL16LSL4sigma=6sigma4.50.9999973.4E-06-7.53.19E-143.19E-143.4E-060.99999799.9997%WorksheetForCalculatingSigmaPerformanceContinuousData702009O##WorksheetForCalculatingProcessSigmaWorksheetForCalculatingProcessSigmaContinuousDataLong-TermContinuousDataLong-Term2.DetermineArea1:FindZ1LookupZ1inNormalTableArea1=1–LookUpArea1=1–NormDist(Z1)=1–()4.DetermineTotalArea:5.Yield=1–TotalArea6.ProcessSigmaComesFromTableLookUpOfYieldTotalArea=Area1+Area2=()+()Yield=1–TotalArea=1–()SigmaST=LookUpValueinSigmaTable(Z1)=NormalTableLookUpforZ1NormDist=()–()()=USL–xsZ1===x100%=3.SkipthisstepifthereisnoLSLArea22.DetermineArea2:FindZ2LookupZ2inNormalTableArea2=LookUp===LSL–xsZ2==(Z2)=NormalTableLookUpforZ2NormDist=()–()()===nXvaluenX+svaluenUSL&ShadeAreaToTheRightnLSL&ShadeAreaToTheLeftsxx+ssUSL=22Area1Area21018LSL=81.LabelTheNormalCurveWithTheFollowing:Example:6.00702009O##WorksheetForCalculatingProcessSigmaWorksheetForCalculatingProcessSigmaContinuousDataLong-TermContinuousDataLong-Term2.DetermineArea1:FindZ1LookupZ1inNormalTableArea1=1–LookUpArea1=1–NormDist(Z1)=1–()4.DetermineTotalArea:5.Yield=1–TotalArea6.ProcessSigmaComesFromTableLookUpOfYieldTotalArea=Area1+Area2=()+()Yield=1–TotalArea=1–()SigmaST=LookUpValueinSigmaTable(Z1)=NormalTableLookUpforZ1NormDist=()–()()=USL–xsZ1===x100%=3.SkipthisstepifthereisnoLSLArea22.DetermineArea2:FindZ2LookupZ2inNormalTableArea2=LookUp===LSL–xsZ2==(Z2)=NormalTableLookUpforZ2NormDist=()–()()===nXvaluenX+svaluenUSL&ShadeAreaToTheRightnLSL&ShadeAreaToTheLeftsxx+ssUSL=22Area1Area21018LSL=81.LabelTheNormalCurveWithTheFollowing:Example:CalculatingSigmaPerformanceDeleteifnoUSLDeleteifnoLSLWorksheetForCalculatingSigmaPerformanceContinuousDataDPMOMethodenter1NumberOfUnitsProcessedN=10000002TotalNumberOfDefectsMadeD=3.4(IncludeDefectsMadeAndLaterFixed)3NumberOfDefectOpportunitiesO=1PerUnit4SolveForDefectsPerMillionOpportunities3.45LookUpProcessSigmaInAbridgedSigmaConversionTableSigma=6.00WorksheetForCalculatingSigmaPerformancePage4