Tired of Trying to Make Histograms in Excel?
Save time with QI Macros easy-to-use add-in!
Let's face it. Excel's Data Analysis Toolpak is cumbersome and the output is fairly basic. It's missing a curve line, spec limits (aka goalposts) and process capability metrics that provide insights into your data.
Up Your Data Analysis Game using QI Macros Histogram Maker.
Draw a Histogram using QI Macros:
- Select your data.
- Select Histograms & Capability from QI Macros menu.
- QI Macros will do the math and draw the graph for you.
What is a Histogram? Why Do They Matter?
Histograms show the spread, or dispersion, of variable data. They are most valuable when they display your customer's requirements as goal posts. Does your data fit or not? Is it centered?
Customer Requirements are the Specification Limits (Goal Posts)
Experts refer to these goal posts as specification limits. There can be both an upper spec limit (USL) and a lower spec limit (LSL) or just one of the two. Data points outside of the spec limits represent products or processes that don't meet customer requirements.
The best histogram maker's will also calculate process capability metrics Cp, Cpk and Pp Ppk. These are numeric values that tell you how well your process is meeting customer requirements.
- Calculates more than 20 process capability analysis metrics including Cp Cpk and Pp Ppk.
- Draws a bell curve.
- It is interactive:
- Calculations can be viewed and updated in the Excel worksheet created by QI Macros.
- Allows you to experiment with how spec limits impact Cp Cpk by changing them in the histogram calculations worksheet.
- Allows you to adjust histogram bin intervals and the approximate number of bars.
Which Histogram do you Want to Send to Your Boss or Customer?
I am very impressed with QI Macros Software. I work with Excel eight hours a day and thought that I had written macros that made me efficient. The Control Charting and Histogram macros in QI Macros alone have saved me hours of work and allowed me to present data to management in a format that is meaningful.
- Kyle Dopp
First Choice Solutions
Stop Struggling with Histograms!
Start creating your Histograms in just minutes.
QI Macros Draws These Charts Too!