IR Chart with SigmaXL

What is an IR Chart?

The IR chart (also called individual-moving range chart or I-MR chart) is a popular control chart for continuous data with subgroup size equal to one.

  • The I chart plots an individual observation as a data point.
  • The MR chart plots the absolute value of the difference between two consecutive observations in individual charts as a data point.

If there are n data points in the I chart, there are n –1 data points in the MR chart. The I chart is valid only if the MR chart is in control. The underlying distribution of the I-MR chart is normal distribution.

I Chart Equations

I Chart (Individuals Chart)

Data Point:IR chart EQ0

Center Line:IR chart EQ1

Control Limits:IR chart EQ2

Where: n is the number of observations.

MR-Chart Equations

MR Chart (Moving Range Chart)

Data Point: IR chart EQ3

Center LineIR chart EQ4

Upper Control Limit:IR chart EQ5

Lower Control Limit: 0

Where: n is the number of observations.

Use SigmaXL to Plot I-MR Charts

Data File: “IR” tab in “Sample Data.xlsx”

Steps to plot IR charts in SigmaXL:

  1. Select the entire range of data
  2. Click SigmaXL -> Control Charts -> Individuals & Moving Range
  3. A new window named “Individuals and Moving Range” appears with the selected range automatically populated into the box below “Please select your data”.
  4. Click “Next>>”
  5. A new window named “Individuals and Moving Range Chart” pops up.
  6. Select “Measurement” as the “Numeric Data Variable (Y)”
  7. Check the checkbox of “Test for special causes”
  8. Click “OK>>”
  9. The IR charts appear in the newly generated tab “Indiv & MR Charts (1)”.

I-MR Charts Diagnosis

Model summary: The I-MR Chart (Individuals’ Chart) above shows that test 6 and 5 fail and the table above calls out the data observations that failed these tests. Also, since the MR chart is out of control, the I chart is invalid. In the MR Chart (Moving Range Chart): Two data points fall beyond the upper control limit. This indicates the MR chart is out of control (i.e., the variations between every two contiguous individual samples are not stable over time). We need to further investigate the process, identify the root causes that trigger the outliers, and correct them to bring the process back in control.