Converting DPMO to SIGMA - Seeking Forumula

Elsmar Forum Sponsor
R

rivet guy

#2
JimDad

Motorola has a book with tables.

sigmas DPMO(npmo) non-conformities or ppm
1 317,400
2 45,400
3 2,700
4 63
5 0.57
6 0.002
7 0.000003

This data above doesn't include a 1.5 sigma shift on either side of the median.

The book title is The Nature of 6 Sigma Quality from the Motorola University Press.
 
J

Jimdad

#4
Thanks for the feedback folks, I really need to find the formula. Unfortunately, the table does not produce a sigma for a specific DPMO and I do not have the entire 2000 office suite to utilize Pyzdek's converte page.

Still seeking directions,,
Jim
 
K

Ken K.

#7
Here is a formula (ready?)

Sigma =SQRT(LN(1/(1-EXP(-B24/1000000))^2))-(2.55155+0.802853*SQRT(LN(1/(1-EXP(-B24/1000000))^2))+0.010328*SQRT(LN(1/(1-EXP(-B24/1000000))^2))^2)/(1+1.432788*SQRT(LN(1/(1-EXP(-B24/1000000 ))^2))+0.189269*SQRT(LN(1/(1-EXP(-B24/1000000))^2))^2+0.001308*SQRT(LN(1/(1-EXP(-B24/1000000))^2))^3)+1.5

where B24 is DPMO

This formula is accurate to two decimal places between Sigma = 3.2 - 9.0, and one decimal between 2.5 & 3.2, and shouldn't be used for Sigma < 2.5

If you're using Excel you can use:
Sigma =NORMINV(1-B24/1000000,1.5,1)

The Excel function is accurate to 2 decimal places between Sigma = 1.4 - 5.7, and to 1 decimal place for Sigma = 5.7 - 6.1
 
J

Jimdad

#9
Been there, I don't have the complete MS 2000 suite to utilize the converter.


Thanks for the feedback.


Jim
 
G

GaryC

#10
DPMO to sigma is simple. Go to normal tables with your DPMO, get the z value and add 1.5. That is your sigma value.

Use the paste function in Excel for the most accurate normal tables.

GaryC
 
Thread starter Similar threads Forum Replies Date
Q Converting Manufacturing Drawings from a Contract Supplier ISO 13485:2016 - Medical Device Quality Management Systems 7
N Converting ETO Residual Limits from PPM to mg ISO 13485:2016 - Medical Device Quality Management Systems 6
P Converting DMF III into eCTD (Electronic Common Technical Document) Medical Information Technology, Medical Software and Health Informatics 4
T Converting an ISO Class 8 Cleanroom to ISO 7 Various Other Specifications, Standards, and related Requirements 4
N Converting Paper Records to Electronic Format Records Document Control Systems, Procedures, Forms and Templates 6
V Converting Newtons to Newton Meters APQP and PPAP 4
optomist1 Converting Defect Rate To Capability index Capability, Accuracy and Stability - Processes, Machines, etc. 11
B Conversion and Rounding Standard for converting metric to english and vice versa Other ISO and International Standards and European Regulations 4
A Converting 1-Sided Design Tolerance to a Bilateral Tolerance Statistical Analysis Tools, Techniques and SPC 8
D Converting to Electronic Document Control - Procedure Content ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 19
Stijloor Converting a Bear... Funny Stuff - Jokes and Humour 0
optomist1 ASME GD&T Certification Test - Converting Coordinate Tolerances to Profile Tolerances Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
J Converting SOUP to "SOKP" ... IEC 62304 - Medical Device Software Life Cycle Processes 1
M Converting PowerPoint Presentations into MS Word Documents After Work and Weekend Discussion Topics 6
N Thermocouple Calibration - Digital Display vs. Converting the Millivolt into ?C General Measurement Device and Calibration Topics 8
R Converting Best Measurement (BMC) to Calibration & Measurement Capability (CMC) Nonconformance and Corrective Action 2
A Basic Math training - I.e. fractions converting from inches to mm, etc. ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
I Converting mG(milli g's of acceleration) to dB(deciBel) Misc. Quality Assurance and Business Systems Related Topics 20
J Converting solid model formats for a Calypso CMM Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Q Curve Surface Roughness Measurement & Converting Ra to Rz General Measurement Device and Calibration Topics 8
Sidney Vianna Converting PowerPoint presentations into video - software recommendations? After Work and Weekend Discussion Topics 12
A CMM Software Conversion - Converting from Zeiss/Calypso to Brown & sharpe PCDMIS Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
ScottK Learning about converting an AutoCAD .dwg to a .STEP file Manufacturing and Related Processes 5
B Converting from QS9000 to TS 16949 ... HOW? WHO? HOW MUCH? IATF 16949 - Automotive Quality Systems Standard 2
J Converting torque to pressure - One for the Math Folks Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
M Converting ISO9001:1994 to new ISO9001:2000 - Transition ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
C Converting to Process Audits - Seeking: Process Audit Form layout Process Audits and Layered Process Audits 4
J Table for converting Cp values into corresponding Capability % Statistical Analysis Tools, Techniques and SPC 1
Z DPMO? Metrics for Engineering Drawings Six Sigma 1
D Siemens MES software DPMO Calculation Six Sigma 4
B Calculating Combined DPMO and Sigma Level for Two or More Different Work Areas Six Sigma 3
R Six Sigma / DPMO Related Inquiry - A 6 Sigma related Statistical Sampling question Six Sigma 2
optomist1 DPM (Defects per Million) vs. DPMO (Defects per Million Opportunities) Capability, Accuracy and Stability - Processes, Machines, etc. 4
1 What are TOP, DPU, DPO, DPMO? Mult-CTQ (discrete) ZST - Is this a probability? Six Sigma 1
S Confusion DPU, PPM & DPMO vs. Sigma Level - ASQ Six Sigma Black Belt hand book Six Sigma 14
T DPMO (defects per million opportunities) - Key word being OPPORTUNITIES Six Sigma 9
ScottK Realistically - What kind of DPMO and sigma for a $5.00 part? Six Sigma 30
Y Definition DPPM - Quality Indicator? Using DPPM instead of DPMO as our OQA quality indicator Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 4
S PPM vs. DPMO - Confused on how to use Six Sigma 2
Marc Definition DPMO - Defects Per Million Opportunities Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 1
B How to decide the ?U? to calcuate DPU and "opportunity" of DPMO Six Sigma 8
B How to define and Calculate the DPU, DPMU, DPMO, Yield, Rolled Throughput Yield (RTY) Manufacturing and Related Processes 3
J Definition DPMO and PPM - Differences - Defects Per Million Opportunities and Parts Per Million? Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 7
J How to calculate the sigma level of a process and Relationship of DPMO Six Sigma 7
S DPMO (Defects Per Million Opportunities) vs. RTY (Rolled-Throughput-Yield) Six Sigma 7
S DPMO calculation for Testing stations- ideal way? High volume PCB manufacture Six Sigma 8
F DPMO (Defects Per Million Opportunities) Calculation Statistical Analysis Tools, Techniques and SPC 5
M Industry DPMO Standards - Contract Electronics Manufacturing processes Statistical Analysis Tools, Techniques and SPC 2
T Calculating DPMO for Exponential Distributions Statistical Analysis Tools, Techniques and SPC 4
michellemmm What is the Cost of six sigma certification? Six Sigma 5
Similar threads


















































Top Bottom