Include Top

How Do I Create X-Bar & S Charts in Excel Using SigmaXL?

X-Bar & S Charts


  1. Open the file Catapult Data Xbar Control Charts.xlsx. Each operator fires the ball 3 times. The target distance is 100 inches. The Upper Specification Limit (USL) is 108 inches. The Lower Specification Limit (LSL) is 92 inches.
  2. Select B2:F22; here, we will only use the first 20 subgroups to determine the control limits.
  3. Select SigmaXL > Control Charts > X-Bar & S.
  4. Do not check Use Entire Data Table!

    Data Selection

  5. Click Next. Select Subgroups across Rows, select Shot 1, Shot 2, Shot 3, click Numeric Data Variables (Y) >>; select Operator, click Optional X-Axis Labels >>. Check Tests for Special Causes as shown:

  6. X-Bar Variables

  7. Click OK. Resulting X-bar & S charts:

    X-Bar and R Chart

  8. This is currently a stable catapult process. Subgroups 21 to 25 were added afterwards. To add the additional data to this chart, click SigmaXL Chart Tools > Add Data to this Control Chart as shown.

    X-Bar and R with Added Data

 




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

Ph: 1.888.SigmaXL (744.6295)

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com