How to Determine Histogram Bin Intervals

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

To show a useful spread of data, you may need to estimate the ideal histogram bin interval. Here's how:

1. Count the number of data points.
2. Take the square root of the number of data points and round up to determine the number of bins required.
3. Divide the specification tolerance (USL-LSL or Max-Min value) by number of bins.

For example:

• 25 data points = 5 bars
• 100 data points = 10 bars

If there are too many bars (e.g., more than 50) to display nicely on the page, we limit the number of bars.

Juran's Quality Control Handbook provides these guidelines for the number of bars and states that they are not "rigid" and should be adjusted when necessary.

• Watch video of how to create a histogram using the QI Macros
• Histogram Examples
• Histogram in Excel
• 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

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma