CHIDOMASTER BLACK BELT · L6S
⚙

Chart guide

p chart

A p chart tracks the share of items that fail a check, period by period, with control limits that widen when fewer items were checked and narrow when more were. It answers one question: has the failure rate really changed?

Claims returned for missing informationp chart of Share returned, 16 periods: average 0.124, with limits that move with each period's sample size. One point is outside the limits: W11 (0.228, above the upper limit). Every other point is inside them.0.050.10.150.20.25W1W5W9W13Share returnedCL 0.124Claims returned for missing informationp chart of Share returned, 16 periods: average 0.124, with limits that move with each period's sample size. One point is outside the limits: W11 (0.228, above the upper limit). Every other point is inside them.0.050.10.150.20.25W1W3W5W7W9W11W13W15Share returnedCL 0.124
Illustrative figures

Share returned: average 0.124; each period's limits from its own sample size
PeriodProportionLimitsSignal
W126/212 = 0.1230.056 to 0.192
W222/198 = 0.1110.054 to 0.195
W331/240 = 0.1290.061 to 0.188
W425/225 = 0.1110.058 to 0.19
W524/187 = 0.1280.052 to 0.197
W629/256 = 0.1130.063 to 0.186
W727/231 = 0.1170.059 to 0.19
W823/204 = 0.1130.055 to 0.194
W926/219 = 0.1190.058 to 0.191
W1030/243 = 0.1230.061 to 0.188
W1152/228 = 0.2280.059 to 0.19Above the upper limit
W1221/196 = 0.1070.054 to 0.195
W1330/251 = 0.120.062 to 0.187
W1425/209 = 0.120.056 to 0.193
W1527/233 = 0.1160.06 to 0.189
W1624/220 = 0.1090.058 to 0.191

Chapter 1

What it shows

Each point is a proportion: the items that failed in a period divided by the items checked in it. The centre line is the overall proportion across all periods. The limits are three standard errors either side of it, and because the standard error depends on how many items were checked, the limits step in and out from one period to the next.

That stepping is the point of the chart. A failure rate of 15% means much more when it comes from 2,000 items than from 20, and the p chart builds that into its limits so you do not have to judge it by eye.

Chapter 2

When to use it

Use it for pass or fail data where each item either has the problem or does not, and the number checked varies: claims returned, appointments missed, orders sent late, forms with an error. Each item counts once, however many things are wrong with it.

Chapter 3

When not to use it

If you count every error on an item rather than whether the item failed, you have defect counts, and a c or u chart is the right one. If the number checked is the same every period, an np chart plots the count directly and is easier to explain. And if the proportion is very small, with most periods showing no failures at all, the chart says little; chart the time or the number of items between failures instead.

Chapter 4

How the limits are worked out

The centre line is the total failures divided by the total checked, across all periods. For each period, the standard error is the square root of the centre line times one minus the centre line, divided by that period's number checked. The limits are the centre line plus and minus three of those standard errors. A lower limit below zero is set to zero.

Chapter 5

Worked example: claims returned for missing information

A benefits team tracked, each week for 16 weeks, how many claims it processed and how many it had to return to the claimant because information was missing. The figures are illustrative, built to show the method.

Across all 16 weeks, 12.4% of claims were returned. Because the weekly volume varied between 187 and 256 claims, the upper limit moved between 18.6% and 19.7%. Week 11 returned 52 of 228 claims, 22.8%, well above its limit of 19.0%: a special cause. No other week is outside its limits, and there is no long run on either side of the centre line.

The useful conversation is about week 11. In a team like this the cause is usually a change upstream: a new version of a form, a guidance note that went out, a partner sending claims in a different way. Find it while people still remember the week. The other weeks, which range from 10.7% to 12.9%, are the same process doing what it does; asking why week 3 was higher than week 2 would be asking about noise.

Chapter 6

The arithmetic

Three steps: the overall proportion, the standard error for each week, and the limits. Each is stated in words first, then written out, then worked for week 11.

The centre line is every returned claim divided by every claim processed, across all the weeks together, not the average of the weekly percentages.

pˉ=∑xj∑nj\bar{p} = \frac{\sum x_j}{\sum n_j}
xjx_j
claims returned in week jj
njn_j
claims processed in week jj
pˉ\bar{p}
the overall proportion, the centre line
Worked with this page's numbers
  1. pˉ=442÷3,552=0.1244\bar{p} = 442 \div 3{,}552 = 0.1244, that is 12.4%

How much a week's proportion can wobble by chance depends on how many claims it held: the standard error.

SEj=pˉ (1−pˉ)njSE_j = \sqrt{\frac{\bar{p}\,(1 - \bar{p})}{n_j}}
SEjSE_j
the standard error of week jj
Worked with this page's numbers
  1. Week 11: SE11=0.1244×0.8756÷228=0.0219SE_{11} = \sqrt{0.1244 \times 0.8756 \div 228} = 0.0219

Each week's limits sit three of its standard errors either side of the centre line; a lower limit below zero is set to zero.

UCLj, LCLj=pˉ±3 SEjUCL_j,\ LCL_j = \bar{p} \pm 3\,SE_j
Worked with this page's numbers
  1. Week 11: UCL11=0.1244+3×0.0219=0.1901UCL_{11} = 0.1244 + 3 \times 0.0219 = 0.1901, that is 19.0%
  2. Week 11 returned 52÷228=0.228152 \div 228 = 0.2281, that is 22.8%: above its limit

Chapter 7

How to make one in a spreadsheet

One row per period with the number checked and the number that failed. Add a column for the proportion. Work out the centre line once, then the upper and lower limits on each row from that row's number checked. Draw the proportion as a line, the centre as a flat line, and the limits as stepped lines, not smoothed ones.

Chapter 8

Where it fits in a project

It is the baseline in Measure for any failure rate, and in Control it shows whether a fix to the failure rate has held. When a project aims to cut a rate, the p chart is also how you show the change was real: a run of points below the old centre line, or points below the old lower limit.

Is the rate really changing?

A free 30 minute discovery call. Bring the weekly counts, and we will see what they say together.

Book a free discovery call