Drop an Excel/CSV column of measurements — the histogram, fitted distribution, and Cp/Cpk update live. Use Save as PDF for a watermarked copy.
Vanguard Quality Partners
Process Capability Toolkit
Capability Analysis & Distribution Fit
Vanguard Quality Partners
Defects Out. Confidence In.
vanguardqualitypartners.com
Supplier / Vendor
Part / Characteristic
Owner / Team
Units
Date
Dimensions
1 Load your measurements One column of numeric readings — Excel, CSV, or pasted
Drop an Excel or CSV file
.xlsx · .xls · .csv — or click to browse
No data loaded yet
Load data to see sample size, mean, and spread …
2 Set limits, fit a distribution The chart fits the curve and computes capability live
Specification limits
Fitted distribution
Histogram bins
10 bins
Chart layout
Load measurements and set at least one spec limit to build the capability chart…
Histogram Fitted curve LSL Target USL
Capability verdict
Load data and enter spec limits to assess capability.
Cp
Potential (within)
—
Cpk
Actual (within)
—
Pp
Overall spread
—
Ppk
Overall actual
—
—
Sample n
—
Mean
—
Std Dev
—
Min – Max
—
Out of Spec
—
Est. PPM
Tolerance to capability · set the Cpk goal per dimension
Load measurements to see the tolerance needed for capability.
3 Capability summary — all dimensions Every characteristic in this study, side by side
DimensionnMeanSpec (LSL–USL)CpCpkPpPpkBest FitStatus
Capability ReportDistribution & capability, one row per dimension
How to use

Drop a single column of measured readings, then enter the LSL and USL from the drawing. The chart bins your data into a histogram and overlays the selected distribution — if the curve doesn't hug the bars, the process likely isn't Normal (try Lognormal or Weibull for skewed data). Cp / Cpk use within-subgroup spread (moving range); Pp / Ppk use the overall spread. A capable process targets Cpk ≥ 1.33. Feed an out-of-spec finding into a 5 Whys or Fishbone to chase the root cause.

Vanguard Quality Partners · Measure. Improve. Excel.
© Vanguard Quality Partners. Template for client use. vanguardqualitypartners.com