Include Top

Individuals Charts: Advanced Limit Options Historical Groups

  1. Open Catapult Data Before After Improvement.xlsx. Click Sheet 1 Tab. This data set contains Catapult firing distances. Before_After denotes before improvement and after improvement. The target distance is 100 inches, with the goal being to hit the target and minimize variation about the target. We would like to use an individuals control chart with historical groups to split the limits demonstrating the before versus after improvement.

  2. Click SigmaXL > Control Charts > Individuals. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.

  3. Select Distance, click Numeric Data Variable (Y) >>; select Operator, click Optional X-Axis Labels >>.

  4. ClickAdvanced Options. Select Specify Historical Groups. Select Before_After, click Historical Groups >>.

    Individuals Chart with Historical Groups

    Note: Process Capability analysis is not permitted when Historical Groups are used.

  5. Click OK. The resulting Individuals Control Chart with split limits based on historical groups is shown, demonstrating a clear process improvement:

  6. Individuals Chart with Historical Groups

Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,

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)