Cp, Cpk and Other Process Capability Metrics

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009



  The QI Macros Histogram calculates several process capability analysis metrics. Descriptions and formulas for these metrics are described below.

Cp and Cpk Process Capability Metrics

  • Cp measures how well the data fits within the spec limits (USL, LSL)
  • Cpk measures how centered the data is between the spec limits.
    A Cpk of 1.33 is considered to be at 4-Sigma.

Use Cp when you have a sample, not the population, and are testing the potential capability of a process to meet customer needs. Cp and Cpk use Sigma estimator.

Sigma estimator Formula

sigma estimator formulas
d2 is a constant based on subgroup size
c4 is a constant based on subgroup size

Xbar = Σ(Xi)/n
Rbar = Average(Ri) (Average of the Ranges in samples)

Cp, Cpk Formula

Cp, Cpk formulas

Cp = (USL-LSL)/(6*sigest)       (Cp > 1.33 is desired)
       Note: Cp cannot be calculated if there is no USL or no LSL.
CpU (upper) = (USL-Xbar)/(3*sigest)
CpL (lower) = (Xbar-LSL)/(3*sigest)

Cpk = Min(CpU,CpL)                (Cpk > 1.33 is desired)

Cr Formula

The Capability Ratio (Cr) indicates what proportion of tolerance is occupied by the data.

Cr = 1/Cp        Cp = 1.33 ~ Cr = 0.75 (data fits 75% of tolerance)

Cpm Formula

Cpm = (USL-LSL)/(6√(sigma2+(Xbar-Target)2))
(Cpm can be used when you have a target value.)

One-Sided Specifications or Unilateral Spec Limits

These equations assume that the process has both upper and lower specification limits.
Until 10/2008, the macros used either CpU (USL) or CpL (LSL) for both Cp and Cpk.
After 10/2008 Cp, Cpk, Cpm and other measures relying on USL/LSL will show "*".

Pp, Ppk Process Performance Metrics

Use Pp when you have the total population and are testing the performance of a system to meet customer needs. Pp, Ppk use standard deviation.

Pp, Ppk formulas

Pp, Ppk formulas

stdev = stdev(Xi)
Pp(sigma) = (USL-LSL)/(6*stdev)       (Pp > 1.33 is desired)
       Note: Pp cannot be calculated if there is no USL or no LSL.
Ppu (upper) = (USL-Xbar)/(3*stdev)
Ppl (lower) = (Xbar-LSL)/(3*stdev)

Ppk(sigma) = Min(Ppu,Ppl)                  (Ppk > 1.33 is desired)

Cp, Cpk vs Pp, Ppk

Use Cp, Cpk when you have a sample and are testing the potential capability of a process to meet customer needs. Cp Cpk use sigma estimator.

Use Pp, Ppk when you have the total population and are testing the performance of a process to meet customer needs. Pp, Ppk use standard deviation.

For example, if you test a sample of 10 widgets from a batch of 100 widgets:

  • Use Cp, Cpk to measure and make a statement about the whole batch of 100 widgets.
  • Use Pp, Ppk to measure and make a statement about just the 10 widgets you measured.

Other Process Metrics

Min-Max

Min = Min(Xi)
Max = Max(Xi)

Z Score

Z scores help estimate the non-conforming PPM.
Z scores standardize +/-3*stdev values into +/-3.

Zlower = (Xbar-LSL)/stdev
Zupper = (USL-Xbar)/stdev

Zbench

Zbench = normsinv(1-(Expected PPM/1,000,000)) Zbench is the Z score for the Expected PPM

ZTarget/Delta Z

ZT (target) = ΔZ= |Xbar-Target|/(stdev)

Ztarget measures how far the average varies from the Target.

ZT < 0.5 is desired (less than 1/2 standard deviation from target)

The target is assumed to be the midpoint between the USL and LSL.

Sample Size Calculator

Variable
Sample Size (SS)
= (ZStdev)/Confidence2
Where:
Z = 1.96 for 95% confidence level
Stdev = standard deviation (or 0.5 Default)
Confidence interval expressed as decimal (e.g., .05 = ±5%)

Attribute
Sample Size (SS)
= (Z2p(1-p))/Confidence2
Where:
Z = 1.96 for 95% confidence level
p = percent defects (0-0.5 = 0-50%)
Confidence interval expressed as decimal (e.g., .05 = ±5%)

Correction for Finite Population
new sample size = SS/(1+ (SS-1)/population)

Defects

defects = number of points outside USL-LSL
% Total Defects = (defects100)/(Total points)

Parts Per Million (PPM) and Expected PPM

PPM = % Total Defects 10000
Expected PPM = (Normsdist(Zlower) + (1-Normsdist(Zupper)))1,000,000

Sigma

If observed PPM > 0, it uses the observed value to calculate Sigma.
If observed PPM = 0, it uses Expected PPM to calculate Sigma.
If both are zero, it defaults to 6 sigma.
If there are no USL/LSL, it leaves it blank.

Other Resources

If you still need more help after reading the following information and our free pdf, consider our Histogram Whitepaper.

Add Histogram Whitepaper download (#W950) $20

The histogram with Cp Cpk and other metrics is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

QI Macros - Download with backup CD & User Guide (#230) $139 + S&H
QI Macros - Download Only - No Shipping or Customs Duties (#W230) $139

 

 

Download
FREE
30-Day Trial



QI Macros SPC Software for Excel

Or Buy It Now
for only $139!
Unconditional
90-Day
Money-Back
Guarantee

Add QI Macros Starter Kit - SPC Software plus training CD and tools book (#275) $197 plus S&H
Add SPC Simplified System - SPC Simplified Book and DVD, Plus SPC Software, Training Cd and Tools Example Book (#285) $297 plus S&H


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training