Using Quality Improvement Tools

Histograms

What: A graphical summary of the frequency distribution of a data set

Why: To identify patterns in process data that might be difficult to determine when looking at numbers

When: Your project involves analysis of continuous data (e.g. dosage size, temperature, time)

How:

  1. Sort and tally individual data points to determine the highest and lowest values
  2. Choose a cell width; narrower is typically better but you might find a need for anywhere fro m6-12 categories of equal width
  3. Determine category boundaries:
    1. Choose a starting point at or just below the lowest value
    2. Put values that fall on the boundary into the next highest cell
  4. Tally the number of data points in each cell
  5. Draw your bar chart [or use a template such as this one from our friends down south at the New South Wales Clinical Excellence Comission) using the vertical axis for category frequency and the horizontal axis for the variable values

This is a summary of the steps presented in the IHI guidelines on creating histograms.

Create a Histogram in Excel

Template: histogram Builder with Adjustable Bin Sizes

Template: From the American Society for Quality