Weighted Pareto Charts to Demonstrate the Cost of Defects
How to Create a Weighted Pareto Chart
- To create a weighted Pareto chart, you will need to calculate the weighted cost of defects. Just multiply the number of defects times the cost per defect to develop a weighted cost. In this example, we calculated the weighted cost (column D) by multiplying columns B and C.
- To create a Pareto Chart using QI Macros, just select the data (Use "Ctrl C" to select non-adjacent columns):
- Then click on QI Macros menu and select Pareto Chart:
- QI Macros does all of the math and draws the Pareto in seconds.
Compare the weighted chart to the unweighted chart below. The weighted Pareto points to Location 6 as the most costly defect category. While the unweighted Pareto chart below, points to Location 8 as having the most defects.
I really like the QI Macros. The Pareto chart is worth the purchase price of the whole deal.
Mike Dean, Ellwood Texas Forge
- Watch Video of Creating a Pareto Chart using the QI Macros
- Summarize Data with a PivotTable and Create a Pareto with One Click
- Pareto Chart Template for Excel
Reasons to Choose QI Macros to Draw Your Six Sigma Charts
- Only $279 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free