IR Chart with SigmaXL

What is an IR Chart with SigmaXL?

The IR chart with SigmaXL (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.

Plot and IR Chart with SigmaXL

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

Steps to plot IR charts with 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)”.
    IR Chart with SigmaXL

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.

Join Our Community

Instant access to hundreds of "How to" articles, Tools, Templates, Roadmaps, Data-Files.. Everything Lean Six Sigma! Come on in! Welcome to our community of Lean Six Sigma certified professionals.


My Interest in This Content is More Closely Related to*
This field is for validation purposes and should be left unchanged.

About Lean Sigma Corporation

Lean Sigma Corporation is a trusted leader in Lean Six Sigma training and certification, boasting a rich history of providing high-quality educational resources. With a mission to honor and maintain the traditional Lean Six Sigma curriculum and certification standards, Lean Sigma Corporation has empowered thousands of professionals and organizations worldwide with over 5,300 certifications, solidifying its position and reputation as a go-to source for excellence through Lean Six Sigma methodologies.