Accendo Reliability

Your Reliability Engineering Professional Development Site

  • Home
  • About
    • Contributors
  • Reliability.fm
    • Speaking Of Reliability
    • Rooted in Reliability: The Plant Performance Podcast
    • Quality during Design
    • Critical Talks
    • Dare to Know
    • Maintenance Disrupted
    • Metal Conversations
    • The Leadership Connection
    • Practical Reliability Podcast
    • Reliability Matters
    • Reliability it Matters
    • Maintenance Mavericks Podcast
    • Women in Maintenance
    • Accendo Reliability Webinar Series
    • Asset Reliability @ Work
  • Articles
    • CRE Preparation Notes
    • on Leadership & Career
      • Advanced Engineering Culture
      • Engineering Leadership
      • Managing in the 2000s
      • Product Development and Process Improvement
    • on Maintenance Reliability
      • Aasan Asset Management
      • CMMS and Reliability
      • Conscious Asset
      • EAM & CMMS
      • Everyday RCM
      • History of Maintenance Management
      • Life Cycle Asset Management
      • Maintenance and Reliability
      • Maintenance Management
      • Plant Maintenance
      • Process Plant Reliability Engineering
      • ReliabilityXperience
      • RCM Blitz®
      • Rob’s Reliability Project
      • The Intelligent Transformer Blog
    • on Product Reliability
      • Accelerated Reliability
      • Achieving the Benefits of Reliability
      • Apex Ridge
      • Metals Engineering and Product Reliability
      • Musings on Reliability and Maintenance Topics
      • Product Validation
      • Reliability Engineering Insights
      • Reliability in Emerging Technology
    • on Risk & Safety
      • CERM® Risk Insights
      • Equipment Risk and Reliability in Downhole Applications
      • Operational Risk Process Safety
    • on Systems Thinking
      • Communicating with FINESSE
      • The RCA
    • on Tools & Techniques
      • Big Data & Analytics
      • Experimental Design for NPD
      • Innovative Thinking in Reliability and Durability
      • Inside and Beyond HALT
      • Inside FMEA
      • Integral Concepts
      • Learning from Failures
      • Progress in Field Reliability?
      • Reliability Engineering Using Python
      • Reliability Reflections
      • Testing 1 2 3
      • The Manufacturing Academy
  • eBooks
    • Reliability Engineering Management DRAFT
  • Resources
    • Accendo Authors
    • FMEA Resources
    • Feed Forward Publications
    • Openings
    • Books
    • Webinars
    • Journals
    • Higher Education
    • Podcasts
  • Courses
    • 14 Ways to Acquire Reliability Engineering Knowledge
    • Reliability Analysis Methods online course
    • Measurement System Assessment
    • SPC-Process Capability Course
    • Design of Experiments
    • Foundations of RCM online course
    • Quality during Design Journey
    • Reliability Engineering Statistics
    • An Introduction to Reliability Engineering
    • An Introduction to Quality Engineering
    • Process Capability Analysis course
    • Root Cause Analysis and the 8D Corrective Action Process course
    • Return on Investment online course
    • CRE Preparation Online Course
    • Quondam Courses
  • Webinars
    • Upcoming Live Events
  • Calendar
    • Call for Papers Listing
    • Upcoming Webinars
    • Webinar Calendar
  • Login
    • Member Home

by Ray Harkins Leave a Comment

Converting A Capability Index to PPM Defective

Converting A Capability Index to PPM Defective

One of the most common questions I get from students in my Process Capability Class is, how can I use the capability index from my process to approximate a defect level for my process?

For most, the answer comes from using a table like this one:

Using this table, we can see that a Cpk (or Ppk) of 1.33 equates to a +/-4 sigma process which yield approximately 63 defects per million parts produced.

To approximate the PPM for your specific Cpk level, you can shift over to Microsoft Excel. It’s easy to see from the table that the “sigma level” is 3 times the capability index (e.g. a Cpk of 1.67 equates to a 5 sigma process.)

To get from the sigma level to an approximate PPM in Excel, you use this formula:

=2*(1-NORM.S.DIST(Z,TRUE))*1,000,000

where Z = the sigma level

Now the astute observer may already see a problem with this approach:

1-NORM.S.DIST(Z,TRUE) gets you to the cumulative portion of defective parts on one side of the curve, namely the side where the specification limit is closest to the arithmetic average of the process. Afterall, the Cpk and Ppk indexes only consider the specification limit closest to the process mean; the opposite side is discarded in the equation.

Multiplying this output by 2 assumes that both sides of the curve yield an equal portion of parts out of specification, resulting in an approximation of the portion defective. This however is a faulty assumption especially for processes that are dramatically shifted to one side or other of the specification range.

A more precise estimation of PPM would require your breaking up Cpk (or Ppk) into its constituents, Cpl and Cpu (Ppl and Ppu). Again, multiplying these indexes by 3 yields their individual sigma levels. Then summing the results of the NORM.S.DIST equations would yield that more precise PPM result:

PPM = [(1-NORM.S.DIST(Z,upper,TRUE)) + (1-NORM.S.DIST(Z,lower,TRUE))] * 1,000,000

For most applications, capability indexes like Cpk and Ppk are rounded to two decimal places. The error resulting from this rounding operation is often greater than the improvement in accuracy by using this two-sided equation. Nonetheless, it’s better to fully understand the assumptions baked into your equations, than to unknowingly allow errors into your work.

For a deep-dive into Process Capability Analysis, sign up for my online class of the same name. I keep the selling price of the class low to allow as many quality and reliability professionals as possible to advance their skillsets and ultimately their careers. Click here to sign up:

Filed Under: Articles, on Tools & Techniques, The Manufacturing Academy

« Data is Beautiful
The New Normal: What Was the Old One? »

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Logo for The Manufacturing Acadamey headshot of RayArticle by Ray Harkins
in the The Manufacturing Academy article series

Join Accendo

Receive information and updates about articles and many other resources offered by Accendo Reliability by becoming a member.

It’s free and only takes a minute.

Join Today

Recent Posts

  • How Reliability Engineers Can Improve Their Communication in Information Sessions
  • FMEA Detection Risk: Insights and Advices
  • How to Structure Your ERM System
  • Rate of Occurrence of Failure
  • What is Six Sigma and How is it Used in Quality Engineering?

© 2023 FMS Reliability · Privacy Policy · Terms of Service · Cookies Policy

This site uses cookies to give you a better experience, analyze site traffic, and gain insight to products or offers that may interest you. By continuing, you consent to the use of cookies. Learn how we use cookies, how they work, and how to set your browser preferences by reading our Cookies Policy.