How Do I Create X-Bar & S Charts in Excel Using SigmaXL?
X-Bar & S Charts
- 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.
- Select B2:F22; here, we will only use the first 20 subgroups to determine the control limits.
- Select SigmaXL > Control Charts > X-Bar & S.
- Do not check
Use Entire Data Table!
- 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:
- Click OK. Resulting X-bar &
S charts:
- 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 & S Charts – Stacked Column Format
- Open Customer Data.xlsx, click on Sheet 1. Click SigmaXL > Control Charts > X-Bar & S. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
- Select Stacked Column Format, select Overall Satisfaction, click Numeric Data Variable (Y) >>; select Order Date, click Subgroup Column or Size >>; select Order Date, click Optional X-Axis Labels >>.
Ensure that Calculate Limits is selected. Check Tests for Special Causes as shown:
Note: Subgroups are always displayed in the same order as given in the rows. They are not sorted by Order Date. - Click OK. The resulting X-bar & S charts are shown:
The moving limits are due to the varying subgroup sizes. This appears to be a stable process, but typically one would want a minimum of 20 subgroups when creating a control chart. This example is for demonstration purposes only.
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