Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Process capability

Estimating process capability

Plot a process capability histogram and compute indices to determine if a process can meet specifications.

This task creates a new process capability analysis report. You can also estimate the process capability directly from a process control analysis report using the Capability command in the Process Capability group on the Analyse-it ribbon tab.
  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Capability, and then click:
    Option Description
    3-up Compute capability ratios and plot a histogram and univariate plot.
    4-up Compute capability ratios and plot a histogram, univariate plot, and normal probability plot.
    6-up Compute capability ratios and plot a histogram, univariate plot, normal probability plot and control charts.
    The analysis task pane opens.
  3. In the Model drop-down menu:
    • If the data are individual observations, select Process variable .
    • If the data are rational subgroups, select Process variable with Subgroups.
  4. In the Process drop-down list, select the quality characteristic variable.
  5. If the data are collected in subgroups, in the Sample size group:
    • If the subgroups are identified by a variable, select Subgroup by identifier variable, and in the Id drop-down list, select the subgroup identifier variable.
    • If the subgroups are a constant size and formed by consecutive number of observations of the process variable, Subgroup size constant, and in the edit box, enter the number of consecutive observations per subgroup.
  6. Optional: If the data are individual observations, in the Id drop-down list, select an identifier variable
  7. In either or both the LSL and USL edit boxes, type the lower and upper specification limits.
  8. Optional: In the Target edit box, type the target value.
  9. Optional: If you are using control charts, in the Sigma estimator drop-down list, select:
    Option Description
    Long-term Use the overall standard deviation of the individual measurements.
    Short-term Use the within-subgroup sigma of the process (using the process control R-, S-, or MR- chart).
  10. Select the Capability ratios, Z benchmark, or Nonconforming units check boxes.
  11. Click Calculate.
Related concepts
Capability ratios (Cp/Pp indices)
Nonconforming units
Z benchmark
Related tasks
Applying phases/stages for each change in a process
Related reference
Dataset layout
Available in Analyse-it Editions
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Capability ratios (Cp/Pp indices)
  •  Z benchmark
  •  Nonconforming units
  •  Estimating process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.