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.- Open Multi-Vari Data.xlsx. Select Sheet Between. First, we will incorrectly use the X-bar & R chart, and then apply the correct I-MR-R chart.
- Click SigmaXL > Control Charts > X-bar & R. Check Use Entire Data Table.
- Click Next. Select
Stacked Column Format. Select Measurement, click
Numeric Data Variable (Y) >>; select unit, click
Subgroup Column or Size >>.
- Click OK. Resulting X-bar & R chart:
- 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).
- Click Sheet Between. Select SigmaXL > Control Charts > Advanced Charts > I-MR-R.
- Click
Next. Select Stacked Column Format. Select
Measurement, click Numeric Data Variable (Y) >>; select
unit, click Subgroup Column or Size >>.
- Click
OK. Resulting I-MR-R chart:

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 (744.6295)
Support: Support@SigmaXL.com
Sales: Sales@SigmaXL.com
Information: Information@SigmaXL.com