p' prime charts in Excel

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 purpose of a p chart is to evaluate process stability when counting the fraction defective (or in many healthcare applications, the fraction meeting requirements).

The p chart works for most data sets. However, if your data meets certain criteria you may need to consider an XmR chart or a p prime chart.

Consider an XmR chart if the denominator does not vary widely from sample to sample and your p chart looks like the one below where the control limits seem too narrow for the data and most points are highlighted as unstable.

Here is an XmR chart run on the same data.

Consider a p prime chart if: the sample sizes in your denominator vary greatly.

A p prime chart will have wider control limits than the p chart and it will have varying control limits that may help identify unstable points not identified by the XmR chart. Here is a p prime chart of the same data.

The QI Macros contain a p prime chart template. Click on the QI Macros pull down menu and select Fill-in-the-blank templates, SPC Charts, p chart to open up the p chart template. Click on the P' chart skyline tab to open up the p prime chart template.

• p chart in excel
• p prime chart formula
• u prime chart
• XmR Individuals Chart
• Other types of control charts

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

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!