How to calculate the sigma level of a process and Relationship of DPMO

J

jackylpt

#1
Hi there,

Now the six sigma is buzzword in many area. My question is how to calculate process sigma level.

For exmaple, suppose there is no shift in process, our process means is 100, taget is also 100,process sigma(by R/d2 calculating) is 1.8, specification is 90--110,

Question1: how to calculate sigma level?
is it (110-90)/6*1.8?
Question2: now I am also confusing how to calculate the cpk of this ?

thanks

michael
 
Elsmar Forum Sponsor
B

Bob Ablondi

#2
Calculating sis sigma

The calculation of a Sigma level, is based on the number of defects per million opportunities (DPMO).

In order to calculate the DPMO, three distinct pieces of information are required:
a) the number of units produced
b) the number of defect opportunities per unit
c) the number of defects

The actual formula is:

DPMO = (Number of Defects X 1,000,000)

((Number of Defect Opportunities/Unit) x Number of Units)

Example:

A manufacturer of computer hard drives wants to measure their Six Sigma level.
Over a given period of time, the manufacturer creates 83,934 hard drives.
The manufacturer performs 8 individual checks to test quality of the drives.
During testing 3,432 are rejected.


Defects 3432 DPMO 5111.158768
Opportunities 83934 Sigma Level 4.1
Defect Opportunities per unit 8


Six Sigma Table: 1 690,000
2 308,000
3 66,800
4 6,210
5 320
6 3.4
 
J

jackylpt

#4
Bob Ablondi said:
The calculation of a Sigma level, is based on the number of defects per million opportunities (DPMO).

In order to calculate the DPMO, three distinct pieces of information are required:
a) the number of units produced
b) the number of defect opportunities per unit
c) the number of defects

The actual formula is:

DPMO = (Number of Defects X 1,000,000)

((Number of Defect Opportunities/Unit) x Number of Units)

Example:

A manufacturer of computer hard drives wants to measure their Six Sigma level.
Over a given period of time, the manufacturer creates 83,934 hard drives.
The manufacturer performs 8 individual checks to test quality of the drives.
During testing 3,432 are rejected.


Defects 3432 DPMO 5111.158768
Opportunities 83934 Sigma Level 4.1
Defect Opportunities per unit 8


Six Sigma Table: 1 690,000
2 308,000
3 66,800
4 6,210
5 320
6 3.4
Dear Bob,

thank you so much for your infomation. I have anther way to calcuate it, but the result is different. Would you please give me some suggestion?

DPU: 3432/83934=0.0408
Y=FPY=e(-DPU)=e(-0.0408)=0.96
probability of a defect {P(d)}=1-Y=1-0.96=0.04
using Z value table is 1.75 sigma

so it is different.

thanks

Michael
 
B

Bob Ablondi

#5
jackylpt said:
Hi there,

Now the six sigma is buzzword in many area. My question is how to calculate process sigma level.

For exmaple, suppose there is no shift in process, our process means is 100, taget is also 100,process sigma(by R/d2 calculating) is 1.8, specification is 90--110,

Question1: how to calculate sigma level?
is it (110-90)/6*1.8?
Question2: now I am also confusing how to calculate the cpk of this ?

thanks

michael
The method shown is with a plus/minus 1.5sigma shift based on Motorola's allowance for process variation in manufacturing.

Bob
 

Tim Folkerts

Super Moderator
#6
That pesky 1.5 sigma shift sure makes life difficult! And the question of what an "opportunity" is!

There is a "Sigma calculator" you can use at
http://www.isixsigma.com/sixsigma/six_sigma_calculator.asp?m=advanced

If you have a situation with...
* 83934 units
* 3432 defective units
* each unit is 1 opportunity

Then you have 4.1% defective = 41,000 DPMO. The calculator above says that if the process is centered then this is a 1.74 sigma process. Using the "standard" 1.5 sigma shift says this is a 3.24 sigma process. (these numbers aren't too hard to come up with - they assume a normal distribution that would produce a similar number of defects at the closer spec limit.)

If you considered each test as an opportunity, then you would have 8 times as many opportunities, and a correspondingly better sigma value.


For the example you gave, with x-bar=100, limits at 90 & 100, and sigma = 1.8, you are currently (110-100)/1.8 = 5.56 sigma from the closest spec limit. However, since the "standard" calculation assumes that the process might drift 1.5 sigma, i.e the center might drift by 1.8*1.5 = 2.7. You would then be only (110 - 102.7)/1.8 = 4.06 sigma from the closer spec limit. This would, I believe, be the "official" sigma level for the process.


Tim F
 
C

CarlosDelgado - 2008

#8
That pesky 1.5 sigma shift sure makes life difficult! And the question of what an "opportunity" is!

There is a "Sigma calculator" you can use at
http://www.isixsigma.com/sixsigma/six_sigma_calculator.asp?m=advanced

If you have a situation with...
* 83934 units
* 3432 defective units
* each unit is 1 opportunity

Then you have 4.1% defective = 41,000 DPMO. The calculator above says that if the process is centered then this is a 1.74 sigma process. Using the "standard" 1.5 sigma shift says this is a 3.24 sigma process. (these numbers aren't too hard to come up with - they assume a normal distribution that would produce a similar number of defects at the closer spec limit.)

If you considered each test as an opportunity, then you would have 8 times as many opportunities, and a correspondingly better sigma value.


For the example you gave, with x-bar=100, limits at 90 & 100, and sigma = 1.8, you are currently (110-100)/1.8 = 5.56 sigma from the closest spec limit. However, since the "standard" calculation assumes that the process might drift 1.5 sigma, i.e the center might drift by 1.8*1.5 = 2.7. You would then be only (110 - 102.7)/1.8 = 4.06 sigma from the closer spec limit. This would, I believe, be the "official" sigma level for the process.


Tim F
I cant accept your apreciation as simple as you say

If is a continuous process, How do you calculate DPMO ..... its depen of the kind of the testing, testing frecuency ........... for me yield must be equal to sigma levels in cetered, normal distribution variable ................... if that we can use the same formula said (Upper Level less media)/sigma.......... we must say exactly what we got real in our process and it work for us ........ theory is not required please...... I dont know if you get my email but is [email protected] and [email protected]........... whenever you want to dicussed it please send it ....... if you know about 6sigma and know your process we can learn join

Best regards
Carlos Delgado
 
Thread starter Similar threads Forum Replies Date
P How to correctly calculate sigma level for production processes Six Sigma 2
J How to calculate the sigma level of a process - Which one is right Six Sigma 3
K How to calculate sigma? Six Sigma 30
B Formula to calculate the Process Sigma from an RPN Six Sigma 17
A Normal Deviation - short cut/method to calculate sigma Statistical Analysis Tools, Techniques and SPC 2
J How do I calculate sigma for attribute data of process - Coating spoliation Six Sigma 5
C Gage R&R - RTT (Total Spec) - New tecnique to calculate R&R involving Six Sigma Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
S Bend allowance formula to calculate per degree per radii Manufacturing and Related Processes 2
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
M How to calculate benefits? Moving some developed non controlled software/automation systems Service Industry Specific Topics 2
qualprod Calculate number of people in processes, considering cycle time/takt time = quantity of people Lean in Manufacturing and Service Industries 9
S How to calculate the maximum allowable hysteresis of a pressure gauge General Measurement Device and Calibration Topics 1
S How to Calculate the producer Risk AQL - Acceptable Quality Level 25
qualprod Methods to Calculate Available Production Rate ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
K Why calculate LCL in P-chart? Statistical Analysis Tools, Techniques and SPC 4
B How to calculate CPK with n = 1 Manufacturing and Related Processes 2
A Add-On software for VMC to calculate setting time, Idle Time, OEE etc.. Manufacturing and Related Processes 2
L How to calculate the Probability of Deficiency of the AQL of an Inspection AQL - Acceptable Quality Level 16
V How to Calculate Unbiasing Constant C4 Statistical Analysis Tools, Techniques and SPC 1
J How to Calculate OEE Indicator for a Workshop (15 Machines) Lean in Manufacturing and Service Industries 6
R How to calculate UCL (Upper COntrol Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 5
T I want to calculate reliability at 750 hours Reliability Analysis - Predictions, Testing and Standards 8
R How To Calculate & Print CDF and Lower Bound CDF value for some t(time) with Minitab? Using Minitab Software 1
N How to calculate the Premium Freight charges Service Industry Specific Topics 4
A How to calculate Mean and standard deviation without sample size in Minitab Using Minitab Software 5
R When do I need to calculate Process OEE? Manufacturing and Related Processes 12
kedarg6500 How to calculate Thread Pitch Diameter for non standard TPI like 5/8" 17.75 NF3 Manufacturing and Related Processes 3
C Definition and Way to Calculate some Metrics Lean in Manufacturing and Service Industries 6
M How calculate P value for Linearity and Bias using Excel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
N Formula that will calculate the NoGo Major Diameter of an M20 x 1.5 6H Thread gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
M How to calculate Cg and Cgk for a 2-Dimensional Area Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
T Calculation Question - Calculate the runner weight for a part Manufacturing and Related Processes 2
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
S Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11 Excel .xls Spreadsheet Templates and Tools 7
M Calculate PPMs by going back to Date of Production or Date Noticed Quality Tools, Improvement and Analysis 7
M How to calculate MTTF (Mean Time to Failure) Reliability Analysis - Predictions, Testing and Standards 1
H How to calculate the Lot Reject Rate Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
L How calculate the number of samples Statistical Analysis Tools, Techniques and SPC 2
A Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
R How to calculate MMC when is placed after datum Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
S Which one is better to calculate, Cpk or Ppk? Statistical Analysis Tools, Techniques and SPC 11
C How to calculate P value on Probability Plot Statistical Analysis Tools, Techniques and SPC 1
S Supplier Disruption Score and how to calculate it Quality Tools, Improvement and Analysis 4
D IAQG OASIS - New tool to calculate Audit Time AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
M How to calculate dimensions of trapezoid ? Quality Tools, Improvement and Analysis 3
J How to calculate Surveillance Audit Days in Corporate Audit Scheme IATF 16949 - Automotive Quality Systems Standard 4
S How to calculate Supplier PPM at Receiving Inspection Document Control Systems, Procedures, Forms and Templates 2
K How to Calculate Sample Size at 95% Confidence Interval on Surface Roughness Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
R How to calculate the value add time? Lean in Manufacturing and Service Industries 2

Similar threads

Top Bottom