Cpk – Lean Six Sigma Moneybelt

Improvement Insights Blog

Posts tagged "Cpk"

Cpk and Hard vs Specification Limits

A customer called upset about Cpk. He had a runout of 0.010, but was getting a very low Cpk. Turns out he’d made the classic mistake of confusing a hard limit (e.g., zero) with a specification limit. I had him use QI Macros with an Upper Specification limit (USL) and no Lower Specification Limit (LSL). His Cpk immediately jumped to a more expected value of 1.78.

Later in the day another customer asked why Cpk is calculated as the minimum of the upper or lower Cpk? Because you use the one closest to the average. I think that customer may have had the same problem, confusing a hard limit with a specification limit.

Posted by Jay Arthur in QI Macros, Six Sigma.

Create a Histogram in Excel Using the QI Macros

Use a histogram to determine the distribution of measurable data and the capability (i.e., the level of performance the customers can consistently expect) of the process. Process capability is determined using your data and the customer’s upper specification (USL) and lower specification limits (LSL).
Its easy to create a histogram in Excel using the QI Macros.  See

http://www.youtube.com/user/QIMacros#p/a/u/2/tqlFKtmAxbU

Posted by Jay Arthur in QI Macros.