The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Statistical Analysis Tools, Techniques and SPC
Forum Username


Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links





Donate and $ Contributor Forum Access
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
manufacturing processes, sigma level, calculation formulas
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 26th February 2011, 09:34 PM
tsider tsider is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Feb 2011
 
Posts: 4
Thanks Given to Others: 4
Thanked 0 Times in 0 Posts
Karma Power: 13
Karma: 10
tsider has less than 100 Karma points so far.
Please Help! Calculation of Sigma Level of Defects for a Manufacturing Process

Hello everyone the forum is great! Anyway I am new here and excuse me for my bad English in advance. I am trying to calculate the sigma level of defects for a manufacturing process for an essay.
The numbers are based on a real factory that produces let's say something like 100 different product lines. I don't have any ASL/LSL. I checked the overall defect rate distribution is normal, I didn't check per line because they are so many of them ;p)

First, I weighted the lines according to what proportion contribute for the general production (like Pareto). The final, overall weighted value of defects was something like 20%.

Then, I tried to convert it to DPMO. It's a compound product and since 2 main controls are made in order to considered good (optical/dimensional), I used 2 at the fraction. However, my DPMO number is something like 15.000, and thus shows my process much better than it really is.

So is it better to rely on the dpu=20% instead? Is there a way to convert it into a sigma level?

Any advice or any comment on the procedure I followed is more than welcome and needed.

Last edited by Stijloor; 26th February 2011 at 10:02 PM. Reason: Typo

Sponsored Links
  #2  
Old 26th February 2011, 09:42 PM
Ajit Basrur's Avatar
Ajit Basrur Ajit Basrur is offline
Forum Administrator

 
Registration Date: Dec 2005
Location: Massachusetts, USA
Age: 50
 
Posts: 5,599
Thanks Given to Others: 1,698
Thanked 2,577 Times in 1,630 Posts
Karma Power: 400
Karma: 15686
Ajit Basrur is appreciated, and has over 1700 Karma points.
Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.Ajit Basrur is appreciated, and has over 1700 Karma points.
Re: Calculation of Sigma Level

Quote:
In Reply to Parent Post by tsider View Post

Hello everyone the forum is great! Anyway i am new here and excuse me for my bad english in advance. I am trying to calculate the sigma level of defects for a manufacturing process for an essay.
The numbers are based on a real factory that produces lets say something like 100 different product lines.i dont have any ASL/LSL.I checked the overall defect rate distribution is normal,i didnt check per line cause they are so much of them;p)

First i weighted the lines according to what proportion contribute for the general production (like pareto).The final,overall weighted value of defects was something like 20%

Then, i tried to convert it to DPMO.Its a compound product and since 2 main controls are made in order to considered good (optical/dimensional),i used 2 at the fraction.However,my DPMO number is something like 15.000,and thus,shows my process much better than it really is.

So its better to rely on the dpu=20% instead?Is there a way to convert it into a sigma level?

Any advice or any comment on the procedure i followed is more than welcome and needed.
Welcome to the Cove

Weekends are bit slow and hence the response may be delayed.

__________________

You canít use up creativity. The more you use, the more you have Ė Maya Angelou
Thanks to Ajit Basrur for your informative Post and/or Attachment!
Sponsored Links

  #3  
Old 26th February 2011, 11:13 PM
Jennifer Kirley's Avatar
Jennifer Kirley Jennifer Kirley is offline
Forum Moderator

 
Registration Date: Jan 2004
Location: Maine, USA
 
Posts: 5,426
Thanks Given to Others: 3,262
Thanked 3,065 Times in 1,753 Posts
Karma Power: 640
Karma: 28325
Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.
Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.Jennifer Kirley is appreciated, and has over 1700 Karma points.
Re: Calculation of Sigma Level of Defects for a Manufacturing Process

Welcome to the Cove!

Ajit is right - it is slow right now. But until we can provide a specific response (I'm sorry to say it's out of my area of expertise) you can still review related threads that are listed at the bottom of this screen.

Also, can you perhaps attach a spreadsheet with some data you are trying to analyze?

__________________

"If you only have a hammer, you tend to see every problem as a nail." Abraham Maslow
Thanks to Jennifer Kirley for your informative Post and/or Attachment!
  #4  
Old 26th February 2011, 11:40 PM
harry harry is offline
Super Moderator

 
Registration Date: Sep 2005
Location: Johore/Malaysia
 
Posts: 6,222
Thanks Given to Others: 1,479
Thanked 2,942 Times in 2,046 Posts
Blog Entries: 2
Karma Power: 694
Karma: 18650
harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.
harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.
Re: Calculation of Sigma Level of Defects for a Manufacturing Process

Pending further response, here are some related threads which you may want to go through.
Thanks to harry for your informative Post and/or Attachment!
  #5  
Old 27th February 2011, 07:25 AM
tsider tsider is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Feb 2011
 
Posts: 4
Thanks Given to Others: 4
Thanked 0 Times in 0 Posts
Karma Power: 13
Karma: 10
tsider has less than 100 Karma points so far.
Re: Calculation of Sigma Level of Defects for a Manufacturing Process

Thank you all!

Sadly i cannot provide real numbers.It is based on my thesis with a real factory so..
I saw the threads,very helpful indeed but sorry to say i am not quite sure yet.

Some extra info:1 production line, 100 product lines of the same product (ceramic tile), 2 quality controls

According to month,the overall distribution of th defect rate (and not categorised to product lines) is a normal distr,N=11 months, Mean=0,1209, (12,09% defect rate) StDev=0,03296.So i was thinking the reason the DPMO is so inacurate is maybe cause it fails the assumption of 1,5 sigma sift and it means like the number of the average defects due to dimensional control and optical control respectively when 1000000 of products are being produced?

I could also acquire the data of how much of them (not according to product lines,overall) are defects because of optical and how much because of dimensional. Maybe i ll calculate a DPMO=E.G 30%DPMO(optical) + 70%DPMO (dimensional) ?Divided by one respectively.Or in the optical by more?(Cause they are more opportunities of failing optically like little holes,black spots etc?).But the number wouldnt be the same as the overall DPMO?

I think that the Dpu already shows me an real estimation of an existing problem (a process tha produces a lot of defectives),so i could just use that for reference after any improvement has been made. But how could i explain to my professors that the Dpmo is so different?Is there a chance to use it accurately and calculate a sigma level?

Sorry i have to present my thesis next week and i am so devastated.Any help is welcome.Thank u all.
  #6  
Old 27th February 2011, 07:48 AM
Stijloor's Avatar
Stijloor Stijloor is offline
Cross Forum Moderator

 
Registration Date: May 2003
Location: Charlotte, North Carolina.
 
Posts: 14,235
Thanks Given to Others: 3,160
Thanked 4,463 Times in 3,158 Posts
Karma Power: 1517
Karma: 24874
Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.
Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.
Re: Calculation of Sigma Level of Defects for a Manufacturing Process

Because the OP is preparing a thesis, I moved this thread to the "Student Research Questions" Forum.

Fellow Moderators, feel free to move again if needed.

Stijloor, Forum Moderator.
  #7  
Old 27th February 2011, 08:42 PM
tsider tsider is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Feb 2011
 
Posts: 4
Thanks Given to Others: 4
Thanked 0 Times in 0 Posts
Karma Power: 13
Karma: 10
tsider has less than 100 Karma points so far.
Please Help! Re: Calculation of Sigma Level of Defects for a Manufacturing Process

Hey its funny talking alone but since i got some progress its better for the potential answerer to review this new post.

My RTY=(sadly my final yield from the process after the quality controls),i mean tis not an 100% Rolled Through out Yield (more like a final yield) is lets say 0,87.

From Schmid and Launsby 1997 :
Sigma level = 0.8406 +sqrt(29.37-2.221 * ln (ppm)) (1.1)
I ve noticed that Breyfogle and others consider DPMO=ppm in this function.

Since it is an one line process, and a compound product (ceramic tile) and it has two controls one after the other but u cannot determine if it could be defective by both of them i just know that from the, e.g 100000 square meters, (thats the unit), 8000 where considered defective from optical defect and 5000 from dimensional defect.Therefore, since i cannot discriminate the interaction between optical and dimensional in defects, i consider, since it is a compound product also,oportunity=1 and,thus, DPU=DPO.

With RTY=0,87 and the formula RTY=e^(DPU) (Breyfogle et al 2003)(1.2) i found DPU,i consider it as i told before equal to DPO and putting it in (1.1) i have sigma level= 2.6 something.

1.Is it right?I realize that is just messing with numbers with no contribution to the project whatsover, since the whole of the factory does not use sigma metric in its other procedures etc. But since my thesis is in Six Sigma i want to present it,but still i am not sure.

2.I saw the distribution of defects by month (N=11) has StDev of 0,03296 and mean=12 (which is also really in accordance with the RTY).If my above calculations are right, 2,6 sigma level- 1,5 drift= my StDev should be 1,1??Something is going wrong here?

3.Thirdly, (so as not to write in this post again:P).As Crucial X the specific weight (im not sure of the terminology) of the pulp in the mills has been determined.I wannat calculate the Cp/Pp.When a mill (4 of them) is changing (is not a fixed time) the company measures the specific weight.So i have the last 100 measurements, of course by several mills.However, i dont think it can be considered a speciment cause these are the whole numbers of the process .The mills are random and not specific by product.However, my subgroup is one or 4?(equal to the mills).If it is considered 4 i dont have equal ''speciments'' by subgroup.Some mills are used more,so i have more specific weights from them.

My data werent normal (a sign of smthng goin wrong?).With Box-Cot transformation it wasnt still.With distribution Minitab analysis i used Johnson transformation and they became.With subgroup 1,Cp and Pp werent good at all.So i think something has to be done in the Improve phase.But, i noticed that Pp # Cp (which in normal distr i think thay have to be equal) and even Cp>Pp (which cannot be possible).So may i have to use subgroups?Something else??

HUGE post i am tottaly 6s sorry,but plz help me graduate!
  #8  
Old 28th February 2011, 04:32 PM
Bev D's Avatar
Bev D Bev D is offline
Heretical Statistician

 
Registration Date: Jan 2003
Location: New England
 
Posts: 2,861
Thanks Given to Others: 1,178
Thanked 1,980 Times in 1,193 Posts
Karma Power: 363
Karma: 15677
Bev D is appreciated, and has over 1700 Karma points.
Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.
Re: Calculation of Sigma Level of Defects for a Manufacturing Process

I'm having trouble following some of what you are doing.

Some commentary you might find helpful (or not at this point)

The formula you cite in 1. is correct IF you are dealing with defects not defectives AND the defects are all independent of each other within a unit. Remember that defects are individual things that can be out of spec and you can have multiple defects on a single unit of product.

The 1.5 sigma shift you reference is a myth and NOT helpful to your analysis - this is why you got an odd result that didn't match your data.

Data in the real world are rarely Normal. There is nothing inherently wrong with a process that is non-Normal.

__________________

Statistics without physics is gambling; Physics without statistics is psychics
Thank You to Bev D for your informative Post and/or Attachment!
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Statistical Analysis Tools, Techniques and SPC

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Sigma Level and Capability - What are Ppu, Ppl, Sigma Level, Sigma Capability fed-up Capability, Accuracy and Stability - Process, Machine, etc. 8 23rd August 2013 06:07 PM
Causes of Disbond Defects in Composites Manufacturing Process nismoynr Manufacturing and Related Processes 7 2nd April 2011 10:50 AM
Calculating Sigma Quality Level - Defects are more than evaluations vganesh27 Quality Tools, Improvement and Analysis 1 7th February 2010 03:57 AM
How to calculate the sigma level of a process and Relationship of DPMO jackylpt Six Sigma 7 1st August 2008 05:27 PM
How to calculate the sigma level of a process - Which one is right jackylpt Six Sigma 3 24th July 2005 05:26 PM



The time now is 07:03 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272