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 © 2009

Quality Assurance and Quality Control Personnel...

Are you tired of drawing histograms in Excel?

• Does the Data Analysis Toolpak interface 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?

You can with the QI Macros SPC Software for Excel. (See example below.)

What is a Histogram?

Histograms show the spread, or dispersion, of data. A QI Macros 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
• How to Analyze a Histogram
• Comparing Histograms
• Process Capability Analysis with Cp, Cpk, Pp, Ppk
• Frequency Histogram
• Cp, Cpk and other Histogram metric formulas

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
for only $139!
Unconditional
90-Day
Money-Back
Guarantee