Frequency Histogram in Excel
home · products · services · search · view cart · contact

NAVIGATION

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

What is a Frequency Histogram?

Like a histogram, frequency histograms show the spread or dispersion of data. Rather than sort the values into bins, a frequency histogram has one bin per value.

Frequency Histogram in Excel Example using QI Macros SPC Software for Excel></p>
<h3><b>Why Use a Histogram?</b></h3>
<p>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. </p>
<div align=

A frequency 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.

In the chart above, there all measurements fall between the LSL and USL which means that the process always delivers on the customer's requirements.

Why Use a Frequency Histogram?

Use a frequency histogram whenever the data has specific values (e.g., 0.65, 0.60, 0.55). This will show exactly how many of each value are in the sample.

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

Download
QI Macros
30-Day Trial Now!