Include Top

How Do I Create I-MR-R/S Control Charts in Excel Using SigmaXL?

I-MR-R Charts

If the within-subgroup variability is much smaller than between subgroup, the classical X-bar & R (or S) chart will not work, producing numerous (false) alarms. The correct chart to use, in this case, is the I-MR-R (or S) chart. The subgroup averages are treated as individual values (I-MR) and the within subgroup ranges are plotted on the Range chart.
  1. Open Multi-Vari Data.xls. Select Sheet Between. We saw this data previously using Multi-Vari charts. First, we will incorrectly use the X-bar & R chart, and then apply the correct I-MR-R chart.
  2. Click SigmaXL > Control Charts > X-bar & R. Check Use Entire Data Table.
  3. Click Next. Select Stacked Column Format. Select Measurement, click Numeric Data Variable (Y) >>; select unit, click Subgroup Column or Size >>.

    X-Bar and R

  4. Click OK. Resulting X-bar & R chart:

  5. X-Bar and R Chart

  6. Almost all of the data points in the X-bar chart are out-of-control! This is due to the small within-subgroup variability (the control limits are calculated from the within-subgroup variability).
  7. Click Sheet Between. Select SigmaXL > Control Charts > Advanced Charts > I-MR-R.
  8. Click Next. Select Stacked Column Format. Select Measurement, click Numeric Data Variable (Y) >>; select unit, click Subgroup Column or Size >>.

    Individuals and Moving Range Chart

  9. Click OK. Resulting I-MR-R chart:

     Individuals Moving Range Chart

Click here to download a Free 30-Day Trial.

Define, Measure, Analyse, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,
Realize

Lean Six Sigma Software Excel Add-in

Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Ph: 1.888.SigmaXL ( 1.888.744.6295 )

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com