CHIDOMASTER BLACK BELT · L6S
⚙

Chart guide

I-MR chart

The I-MR chart is two control charts read together: one of the individual values in time order, and one of how much each value moved from the one before. It is the control chart for data that arrives one value at a time.

Days from enrolment to first sessionIndividuals and moving range chart of Days, 24 points: centre line 11.58, limits 2.22 and 20.94. One point is outside the limits: L17 (24, above the upper limit). Every other point is inside them. The moving range jumps above its limit at L18.0102030Individuals: DaysUCL 20.94CL 11.58LCL 2.22051015L1L6L11L16L21Moving rangeUCL 11.51CL 3.52Days from enrolment to first sessionIndividuals and moving range chart of Days, 24 points: centre line 11.58, limits 2.22 and 20.94. One point is outside the limits: L17 (24, above the upper limit). Every other point is inside them. The moving range jumps above its limit at L18.0510152025Individuals: DaysUCL 20.94CL 11.58LCL 2.2202.557.51012.5L1L4L7L10L13L16L19L22Moving rangeUCL 11.51CL 3.52
Illustrative figures

Days: centre line 11.58, limits 2.22 and 20.94; moving range centre 3.52, limit 11.51
PointValueMoving rangeSignal
L19
L2123
L384
L4113
L5101
L6144
L795
L8134
L9112
L10101
L11122
L1293
L13156
L14114
L15101
L16133
L172411Above the upper limit
L181212Range above its limit
L19102
L20111
L2192
L22134
L23121
L24102

Chapter 1

What it shows

The top chart plots each value in order, with a centre line at the average and control limits either side. The bottom chart plots the moving range: the gap between each value and the one before it, which is how much the process jumps from one point to the next. It is also called an XmR chart.

The limits on both charts come from the average moving range rather than from the overall standard deviation. That matters: a slow drift or a sudden step in the data would inflate an overall standard deviation and hide itself, but it barely changes the point to point jumps.

Chapter 2

When to use it

Use it when each value stands alone: one figure a day, a week or a case. Waiting times for each patient, days to process each claim, cost of each job, a weekly total. In service work this is the chart you will use most, because data rarely arrives in neat samples.

Chapter 3

When not to use it

If your data comes in groups taken at the same time, such as five calls sampled each day, use an X-bar R chart, which uses the information in the groups. If you are counting failures or defects, use a p or c chart. And if the values are heavily skewed, such as waiting times with a long tail, the limits can mislead; look at a histogram first, and consider charting a transformed measure or the median of each period.

Chapter 4

How the limits are worked out

Work out each moving range: the difference between each value and the one before, ignoring the sign. Average them to get the average moving range. The individuals limits are the average plus and minus 2.66 times the average moving range. The moving range chart has a lower limit of zero and an upper limit of 3.267 times the average moving range.

The 2.66 is three divided by 1.128, the constant that turns an average range of two points into an estimate of the standard deviation. You do not need to remember it; you need to know that the limits come from the process's own short term variation.

Chapter 5

Worked example: days to a first session

A skills provider wanted to know whether learners were starting reliably. For 24 learners in the order they enrolled, it recorded the days from enrolment to the first session. The figures are illustrative, built to show the method.

The average is 11.58 days and the average moving range is 3.52 days, which puts the individuals limits at 2.22 and 20.94 days. Learner 17 waited 24 days, above the upper limit: a special cause. On the moving range chart the jump back down after it, 12 days, is above the moving range limit of 11.50; the jump up into it, 11 days, falls just under. One clear signal on either chart is enough to look for a cause.

Every other learner sits inside the limits with no run or trend, so apart from that one case the process is stable: a new learner should expect to start somewhere between 3 and 20 days. The useful question is what happened to learner 17, not why one week was a little slower than another. In this kind of service the answer is often a course start date that was moved, or a referral that sat in an inbox.

In practice, once the cause of a point like that is found, recalculate the limits without it. Here they are calculated from all 24 values so that the arithmetic can be followed.

Chapter 6

The arithmetic

Three short formulas carry the whole chart. Each is stated in words first, then written out, then worked with the 24 learners above.

Each moving range is how far a value moved from the one before it, ignoring whether it went up or down.

MRi=∣xi−xi−1∣MR_i = \lvert x_i - x_{i-1} \rvert
xix_i
the value at point ii, here the days learner ii waited
MRiMR_i
the moving range at point ii
Worked with this page's numbers
  1. Learner 2: MR2=∣12−9∣=3MR_2 = \lvert 12 - 9 \rvert = 3
  2. Learner 17: MR17=∣24−13∣=11MR_{17} = \lvert 24 - 13 \rvert = 11
  3. Learner 18: MR18=∣12−24∣=12MR_{18} = \lvert 12 - 24 \rvert = 12

The centre line is the plain average of the values, and the average moving range is the average of the moving ranges. There is one fewer moving range than values, because the first value has nothing before it.

xˉ=1n∑i=1nxi\bar{x} = \frac{1}{n}\sum_{i=1}^{n} x_iMR‾=1n−1∑i=2nMRi\overline{MR} = \frac{1}{n-1}\sum_{i=2}^{n} MR_i
nn
the number of values, here 24
xˉ\bar{x}
the average, the centre line
MR‾\overline{MR}
the average moving range
Worked with this page's numbers
  1. xˉ=278÷24=11.58\bar{x} = 278 \div 24 = 11.58 days
  2. MR‾=81÷23=3.52\overline{MR} = 81 \div 23 = 3.52 days

The limits sit 2.66 average moving ranges either side of the centre line. The moving range chart has only an upper limit worth drawing, at 3.267 average moving ranges.

UCLx, LCLx=xˉ±2.66 MR‾UCL_x,\ LCL_x = \bar{x} \pm 2.66\,\overline{MR}UCLMR=3.267 MR‾UCL_{MR} = 3.267\,\overline{MR}
2.662.66
three divided by d2=1.128d_2 = 1.128, the constant that turns the average range of two points into an estimate of the standard deviation
3.2673.267
the constant D4D_4 for ranges of two points
UCL, LCLUCL,\ LCL
the upper and lower control limits
Worked with this page's numbers
  1. 2.66×3.52=9.362.66 \times 3.52 = 9.36
  2. UCLx=11.58+9.36=20.94UCL_x = 11.58 + 9.36 = 20.94 days
  3. LCLx=11.58−9.36=2.22LCL_x = 11.58 - 9.36 = 2.22 days
  4. UCLMR=3.267×3.52=11.50UCL_{MR} = 3.267 \times 3.52 = 11.50 days
  5. Learner 17 waited 24 days: 24>20.9424 > 20.94, outside the limit

Chapter 7

How to make one in a spreadsheet

Put the values in time order in one column. In the next, from the second row, take the absolute difference from the row above. Average each column. Work out the three lines for the individuals chart and the upper limit for the moving range chart with the formulas above, and draw each chart as a line with the limits as flat lines.

Use at least twenty values for the limits. Fewer, and the limits move a lot as each new point arrives.

Chapter 8

Where it fits in a project

In Measure, an I-MR chart of the current process is the baseline: how it behaves before anyone changes it. In Control it is the chart that tells the team whether the improvement has held, and when to act.

One value at a time, read properly

A free 30 minute discovery call. Bring a column of numbers in time order, and we will draw the limits together.

Book a free discovery call