Include Top

How Do I Create Individuals & Moving Range Charts in Excel Using SigmaXL?


  1. Open Customer Data.xlsx, click on Sheet 1. Click SigmaXL>Control Charts>Individuals & Moving Range. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
  2. Select Overall Satisfaction, click Numeric Data Variable (Y) >>. Ensure that Calculate Limits is selected.


    IMR Charts


  3. Click OK. Resulting Individuals & Moving Range control chart:

  4. IMR Chart




Define, Measure, Analyze, 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

Phone: 1.888.SigmaXL (744.6295)

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com