Problem Solving with the Box Plots
I was working with a client recently to solve problems with rework and scrap. One of the improvement teams manufactures a diecast cylinder about 3-inches long. The internal diameter varied from the top to the bottom. They took three sample measurements of internal diameter: top, middle and bottom. They asked me how I would illustrate the problem using QI Macros.
My immediate thought: Box and Whisker Plot. So, I selected their data in Excel and created a Box & Whisker Plot using QI Macros add-in:
Box and Whisker Plot created by QI Macros
I added a target line of .25 to the box whisker plot using QI Macros Chart Tools menu:
Analysis of the Box and Whisker Plot
This chart served as the problem statement for the improvement team. From this it was clear that:
- Die 1 was running too large
- Die 2 too low
- Die 3 was closest to the target
The engineers immediately set to work figuring out how to resolve the issues and move the product onto target. They had to go back to the plant to test their countermeasures, but I could tell from their discussions that the problem would soon be solved.
How could a Box and Whisker Plot illustrate your quality problem?
Why Choose QI Macros to Create Box Plots and More?
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
- Only $329 USD
Quantity Discounts Available
- No annual subscription fees
- Free technical support