Capability Analysis with SigmaXL

Understanding Process Capability with SigmaXL

Process capability with SigmaXL measures how well the process performs to meet given specified outcome. It indicates the conformance of a process to meet given requirements or specifications. Capability analysis helps to better understand the performance of the process with respect to meeting customer’s specifications and identify the process improvement opportunities.
Process Capability Analysis Steps

  1. Determine the metric or parameter to measure and analyze.
  2.  Collect the historical data for the parameter of interest.
  3. Prove the process is statistically stable (i.e. in control).
  4. Calculate the process capability indices.

Monitor the process and ensure it remains in control over time. Update the process capability indices if needed.

Process Capability Indices

Process capability can be presented using various indices depending on the nature of the process and the goal of the analysis. Popular process capability indices are:

  • Cp
  • Pp
  • Cpk
  • Ppk
  • Cpm

The Cp index is process capability. It assumes the process mean is centered between the specification limits and essentially is the ratio of the distance between the specification limits to six process standard deviations. Obviously, the higher this value the better, because it means you can fit the process variation between the spec limits more easily. Cp measures the process’ potential capability to meet the two-sided specifications. It does not take the process average into consideration.
High Cp indicates the small spread of the process with respect to the spread of the customer specifications. Cp is recommended when the process is centered between the specification limits. Cp works when there are both upper and lower specification limits. The higher Cp the better, meaning the spread of the process is smaller relative to the spread of the specifications.
Note: Cpm can work only if there is a target value specified.

Perform Process Capability with SigmaXL

Data File: “Capability Analysis” tab in “Sample Data.xlsx”

Steps in SigmaXL to run a process capability analysis:

  1. Select the entire range of data (i.e. the column “HtBk”)
  2. Click SigmaXL -> Process Capability -> Histograms & Process Capability
  3. A new window named “Histogram & Process Cap” pops up with the selected range of data appearing in the box under “Please select your data”
  4. Click “Next>>”
  5. A new window named “Histograms & Process Capability” appears
  6. Select “HtBk” as the “Numeric Data Variables”
  7. Enter 6 in LSL, 6.5 in T and 7 in USL into the boxes for “Lower Spec Limit”, “Target” and “Upper Spec Limit” respectively
  8. Click “OK”
  9. The histogram and the process capability analysis results are in the newly generated tab “Hist Cap (1)”
    Capability Analysis with SigmaXL

Model summary: With Ppk of less than 1.0 we can conclude that the capability of this process is not very good. Anything less than 1.0 should be considered not capable and we should strive for Ppk to reach levels of greater than 1 and preferably over 1.67.

Join Our Community

Instant access to hundreds of "How to" articles, Tools, Templates, Roadmaps, Data-Files.. Everything Lean Six Sigma! Come on in! Welcome to our community of Lean Six Sigma certified professionals.


My Interest in This Content is More Closely Related to*
This field is for validation purposes and should be left unchanged.

About Lean Sigma Corporation

Lean Sigma Corporation is a trusted leader in Lean Six Sigma training and certification, boasting a rich history of providing high-quality educational resources. With a mission to honor and maintain the traditional Lean Six Sigma curriculum and certification standards, Lean Sigma Corporation has empowered thousands of professionals and organizations worldwide with over 5,300 certifications, solidifying its position and reputation as a go-to source for excellence through Lean Six Sigma methodologies.