Include Top

How Do I Create Capability Combination Report for Individuals/Subgroups in Excel Using SigmaXL?

Capability Combination Report (Individuals)

  1. Open the file Delivery Times.xlsx.

  2. Click SigmaXL >Process Capability > Capability Combination Report (Individuals).

  3. Select Delivery Time Deviation, click Numeric Data Variable (Y) >>. Enter USL = 10, Target = 0, LSL = -10, as shown below:

  4. Capability Combination Report Individuals

  5. Click OK. The resulting Process Capability Combination report is shown below:

  6. Process Capability Report

    Individuals Chart

  7. Cp is the “best case” potential capability index. Ppk is the “worst case” actual performance. If Cp is excellent (say Cp =2) and Ppk is poor (say Ppk < 1), this indicates that the process can be dramatically improved through centering and stabilizing. If Cp is poor, you will have to implement fundamental improvements using DMAIC to address common cause variation. If Ppk = Cp, this indicates that the process is centered and stable, and the short-term (within subgroup) variation is the same as the long-term (overall) variation.

  8. Cpm is a similar statistic but it incorporates a penalty for deviation from target.

  9. On a technical note regarding compatibility with other software tools, please be advised that SigmaXL does not use unbiasing constants when calculating Overall StDev, Pp, Ppk and Cpm. This is done in order to ensure that the calculated Overall StDev matches the results given in Descriptive Statistics. Note that Within StDev, Cp and Cpk are based on control chart techniques (MR-bar/d2 for Individuals Chart, R-bar/d2 for X-Bar & R, S-bar/c4 for X-Bar & S).


Capability Combination Report (Subgroups)

  1. Open the file Catapult Data – Xbar Control Charts.xlsx. Each operator fires the catapult 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 process capability (subgroups 21 to 25 are studied later in Control Phase Tools: Statistical Process Control (SPC) Charts: Part B - X-Bar & Range Charts).

  3. Select SigmaXL > Process Capability > Capability Combination Report (Subgroups).

  4. Do not check Use Entire Data Table!

  5. Data Selection - Cap Combo Report Subgroups

  6. 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 >>. Select X-Bar & R Charts. Check Tests for Special Causes. Enter USL = 108, Target = 100, LSL = 92, as shown:

  7. Capability Combination Report Subgroups

  8. Click OK. The resulting Process Capability Combination report is shown below:

  9. Process Capability Combination Report

    Process Capability Combination Report2

    Process Capability Combination Report2

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)