Home » Histograms & Capability Analysis » Histogram Template

Histogram Template in Excel with Cp, Cpk

Tired of Using Excel's Data Analysis Toolpak?

• Does the Excel Data Analysis Toolpak take too long and require too many steps?
• Is it difficult to show specification limits or the normal curve on your histogram?
• Is it too hard to calculate process capability statistics? Defect rates? Sigma?

Save Time and Headaches with QI Macros Histogram Template for Excel

To use the Excel histogram template:

1. Just click on QI Macros Menu, Capability Templates and Histogram with Cp Cpk.
2. Input your data and spec limits into the yellow shaded areas on the Excel worksheet.
3. The histogram chart and bell curve is created to the right.
4. Process capability metrics Cp Cpk Pp Ppk are calculated using sigma estimator.
5. To switch between estimators, change cell R2 to 1) Pooled SD, 2) Sbar or 3) Rbar estimators:

What is Cool about QI Macros Histogram Template for Excel?

Interactive Features: Change the spec limits or sigma estimator formula to see how it impacts Cp Cpk and Pp Ppk.

Multiple Template Options: The template is actually made up of several worksheets:

• Use the Compare Two Histograms Template to view two histograms on the same worksheet.
• Histogram Between-Within: uses slightly different formulas for Cp and Cpk.
• Use the Histogram template for Weibull Analysis to analyze failure rates.

---

Why Choose QI Macros to Perform Capability Analysis and Draw Histograms?