80 20 RuleNeed 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

Buy SPC for Excel Download Free Trial

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)

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

Have Questions? Contact Us