Need a Pareto diagram to separate the vital few from the trivial many?
- Types of defects
- Customer complaints types
- Kinds of injuries in a plant
- Reasons for returned goods
- Downtime reasons
- Types of infections in a hospital
- Reasons for late deliveries
Watch a Video Highlighting How to Make a Frequency Pareto Diagram
Join the thousands separating the "vital few" from the "trivial many" using SPC for Excel
Pareto Diagrams and SPC for Excel
Our SPC software, SPC for Excel, easily creates Pareto diagrams - a great visual way to separate the vital few from the trivial many. There are three Pareto options:
- Frequency - totals the frequency of occurrence by category (e.g., number of returns by product)
- Defect - totals reasons for defects (e.g., reasons for customer returns)
- Variables - totals frequency for categories for different levels of a variable (e.g, defects by shift)
- Two-Level - creates a two-level Pareto diagram (variable -defect)
Pareto Diagram Features
- New data easily added
- Data can be in rows or columns
- Turn cumulative line on or off
- Add dates of data collection
- Option to create other category for frequencies below a certain value
- Format changes maintained when Pareto diagram is updated
- Option to color the vital few
- Option to set the gap between the bars