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

I-MR-R Charts

1. 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.


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 >>.

   
   
   
   

4. 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).


5. Click Sheet Between. Select SigmaXL > Control Charts > Advanced Charts > I-MR-R.


6. Click Next. Select Stacked Column Format. Select Measurement, click Numeric Data Variable (Y) >>; select unit, click Subgroup Column or Size >>.
   
   
   
   
7. Click OK. Resulting I-MR-R chart:
   
   
   
   This chart is much cleaner, showing a stable Individuals and Range chart. The MR chart may be trending up, but we would want to collect more data before making this conclusion. Typically, you want at least 20 (30 preferred) subgroups before calculating final control limits.