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.
| Point | Value | Moving range | Signal |
|---|---|---|---|
| L1 | 9 | ||
| L2 | 12 | 3 | |
| L3 | 8 | 4 | |
| L4 | 11 | 3 | |
| L5 | 10 | 1 | |
| L6 | 14 | 4 | |
| L7 | 9 | 5 | |
| L8 | 13 | 4 | |
| L9 | 11 | 2 | |
| L10 | 10 | 1 | |
| L11 | 12 | 2 | |
| L12 | 9 | 3 | |
| L13 | 15 | 6 | |
| L14 | 11 | 4 | |
| L15 | 10 | 1 | |
| L16 | 13 | 3 | |
| L17 | 24 | 11 | Above the upper limit |
| L18 | 12 | 12 | Range above its limit |
| L19 | 10 | 2 | |
| L20 | 11 | 1 | |
| L21 | 9 | 2 | |
| L22 | 13 | 4 | |
| L23 | 12 | 1 | |
| L24 | 10 | 2 |
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.
- the value at point , here the days learner waited
- the moving range at point
- Learner 2:
- Learner 17:
- Learner 18:
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.
- the number of values, here 24
- the average, the centre line
- the average moving range
- days
- 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.
- three divided by , the constant that turns the average range of two points into an estimate of the standard deviation
- the constant for ranges of two points
- the upper and lower control limits
- days
- days
- days
- Learner 17 waited 24 days: , 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.
How to read any control chart, the rules, and which type to use.
The chart guide All the chartsEvery chart by the job it does: see variation over time, find the biggest cause, compare groups, map a process.
The method Lean Six SigmaWhat the method is, how a project runs from first walk to lasting control, and what it takes.
For your first project The DMAIC Project Charter PackA one page charter, a problem statement worksheet and a baseline workbook, so the first meeting ends with a problem everyone will sign.
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