Histogram in Excel with Cp, Cpk

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Quality Assurance and Quality Control Personnel...

Are you tired of drawing histograms in Excel?

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

Its easy to draw histograms with the QI Macros SPC Software for Excel.

What is a Histogram?

Histograms show the spread, or dispersion, of variable data. The customer's upper specification (USL) and lower specification limits (LSL) determine how well the process delivers on customer requirements.

What is cool about the QI Macros Histogram?

Just select your data and select Histogram with Cp Cpk from the QI Macros menu. The macro will prompt you for spec limits and will create a histogram and calculate process capability metrics for you. All of the calculations can be viewed in the data sheet created by the macro. You can see how the spec limits impact Cp Cpk by changing them in the data sheet and you can adjust bin intervals and the approximate number of bars.

Why Use a Histogram?

Use a histogram to determine the distribution of measurable data and the capability (i.e., the level of performance the customers can consistently expect) of the process.

In the chart above, there are measurements below the LSL and above the USL which means that the process doesn't always deliver on the customer's requirements.

Histogram Resources

• Histogram Examples
• How to Determine Histogram Bin Interval
• How to Analyze a Histogram
• Comparing Histograms
• Process Capability Analysis with Cp, Cpk, Pp, Ppk
• Frequency Histogram
• Cp, Cpk and other Histogram metric formulas
• Histogram with Cp and Cpk validation using Ford Data

Histograms are just one of the tools included in the QI Macros for Excel SPC Software for Excel.

It's Easy to Create Histograms in Excel Start Now

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!