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 help people think!

Copyright © 2008

Histogram in Excel

What is a Histogram?

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

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

• Watch video of how to create a histogram using the QI Macros
• Histogram Examples
• How to Determine Histogram Bin Interval
• Make a Histogram in Excel
• How to Analyze a Histogram
• Comparing Histograms
• Process Capability Analysis with Cp, Cpk, Pp, Ppk
• Frequency Histogram
• Frequency Histogram Examples

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

Download
FREE
30-Day Trial

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee