Accendo Reliability

Your Reliability Engineering Professional Development Site

  • Home
  • About
    • Contributors
    • About Us
    • Colophon
    • Survey
  • Reliability.fm
    • Speaking Of Reliability
    • Rooted in Reliability: The Plant Performance Podcast
    • Quality during Design
    • CMMSradio
    • Way of the Quality Warrior
    • Critical Talks
    • Asset Performance
    • 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
  • Articles
    • CRE Preparation Notes
    • NoMTBF
    • on Leadership & Career
      • Advanced Engineering Culture
      • ASQR&R
      • Engineering Leadership
      • Managing in the 2000s
      • Product Development and Process Improvement
    • on Maintenance Reliability
      • Aasan Asset Management
      • AI & Predictive Maintenance
      • Asset Management in the Mining Industry
      • CMMS and Maintenance 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
      • RCM Blitz®
      • ReliabilityXperience
      • Rob’s Reliability Project
      • The Intelligent Transformer Blog
      • The People Side of Maintenance
      • The Reliability Mindset
    • on Product Reliability
      • Accelerated Reliability
      • Achieving the Benefits of Reliability
      • Apex Ridge
      • Field Reliability Data Analysis
      • Metals Engineering and Product Reliability
      • Musings on Reliability and Maintenance Topics
      • Product Validation
      • Reliability by Design
      • Reliability Competence
      • Reliability Engineering Insights
      • Reliability in Emerging Technology
      • Reliability Knowledge
    • 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
      • Institute of Quality & Reliability
      • Integral Concepts
      • Learning from Failures
      • Progress in Field Reliability?
      • R for Engineering
      • Reliability Engineering Using Python
      • Reliability Reflections
      • Statistical Methods for Failure-Time Data
      • Testing 1 2 3
      • The Hardware Product Develoment Lifecycle
      • The Manufacturing Academy
  • eBooks
  • Resources
    • Accendo Authors
    • FMEA Resources
    • Glossary
    • Feed Forward Publications
    • Openings
    • Books
    • Webinar Sources
    • Journals
    • Higher Education
    • Podcasts
  • Courses
    • Your Courses
    • 14 Ways to Acquire Reliability Engineering Knowledge
    • Live Courses
      • Introduction to Reliability Engineering & Accelerated Testings Course Landing Page
      • Advanced Accelerated Testing Course Landing Page
    • Integral Concepts Courses
      • Reliability Analysis Methods Course Landing Page
      • Applied Reliability Analysis Course Landing Page
      • Statistics, Hypothesis Testing, & Regression Modeling Course Landing Page
      • Measurement System Assessment Course Landing Page
      • SPC & Process Capability Course Landing Page
      • Design of Experiments Course Landing Page
    • The Manufacturing Academy Courses
      • An Introduction to Reliability Engineering
      • Reliability Engineering Statistics
      • An Introduction to Quality Engineering
      • Quality Engineering Statistics
      • FMEA in Practice
      • Process Capability Analysis course
      • Root Cause Analysis and the 8D Corrective Action Process course
      • Return on Investment online course
    • Industrial Metallurgist Courses
    • FMEA courses Powered by The Luminous Group
      • FMEA Introduction
      • AIAG & VDA FMEA Methodology
    • Barringer Process Reliability Introduction
      • Barringer Process Reliability Introduction Course Landing Page
    • Fault Tree Analysis (FTA)
    • Foundations of RCM online course
    • Reliability Engineering for Heavy Industry
    • How to be an Online Student
    • Quondam Courses
  • Webinars
    • Upcoming Live Events
    • Accendo Reliability Webinar Series
  • Calendar
    • Call for Papers Listing
    • Upcoming Webinars
    • Webinar Calendar
  • Login
    • Member Home
Home » Articles » on Tools & Techniques » The Manufacturing Academy » Converting A Capability Index to PPM Defective

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

About Ray Harkins

Ray Harkins is a senior manufacturing professional with over 25 years of experience in manufacturing engineering, quality management, and business analysis.

During his career, he has toured hundreds of manufacturing facilities and worked with leading industry professionals throughout North America and Japan.

« 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

  • The Hidden Power of the P-Diagram in Engineering Design
  • 4: Design & Planning – Part 1: Design
  • Why Weibull is so popular?
  • How to Judge a Reliability Book
  • Deciding When to Do a Reliability Failure Study

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

Book the Course with John
  Ask a question or send along a comment. Please login to view and use the contact form.
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.