Home » Key Tools » Pareto Charts » Weighted Pareto Chart

Weighted Pareto Charts to Demonstrate the Cost of Defects

How to Create a Weighted Pareto Chart

1. 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:
   
   
2. To create a Pareto Chart using QI Macros, just select the data (Use "Ctrl C" to select non-adjacent columns):
   
   
3. Then, click on the QI Macros menu and select "Pareto Chart":
   
   
4. 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

Learn More...

• 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