p Prime Chart Formula

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

The p prime chart (p' chart or modified p chart) works much like an XmR chart.

1. Convert the p values to z values.
2. Calculate the moving range of the z values.
3. Use these values to calculate sigma-estimator.
4. Use the sigma estimator to adjust the control limits.

Here is the formula used to calculate a p prime chart.

Other Resources

• Create a p prime chart in Excel using the QI Macros
• Create a p chart in Excel using the QI Macros
• Create a u prime chart in Excel using the QI Macros
• Other control chart formulas

The p prime control chart 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

Try QI Macros
FREE
For 30-Days

Or Buy It Now!