Pareto Analysis Template (Excel XLSX)

Introduction
Pareto Analysis and Pareto Charts in particular are one of the most critical tools for consultants and those involved in managing quality; innovation; transformation and change. Why? For a whole host of reasons including that they help identify and provide strong evidence as to where an organization should focus on improvement and help organizations manage change.

With these templates all you need to do is enter your data and the Pareto Charts will automatically generate. You can then simply lift them into reports, documents, presentations, include online among many others. The Pareto Analysis templates will present you with powerful information to support effective decision making and help organizations develop, change and grow. They are a key tool for anyone involved in change, transformation and quality management.

What is Pareto Analysis?
The chart is named after the Italian economist Vilfredo Pareto who gave his name to the Pareto principle. This principle identifies the vital few ? that roughly 80% of effects come from 20% of the causes. In consultancy; change; improvement and quality management, it helps focus attention. For example that:
•  roughly 20% of an organization's processes contain 80% of the problems such as time, cost, errors or complaints. Therefore, rather than try to improve or redesign all processes, by focusing on the 20% (the vital few) you can maximise the impact. Learning can then be applied to the remainder (the useful many).
•  around 20% of customers contribute 80 percent of a business's sales. Therefore, the idea is to focus on the customer journey for those customers first (again the vital few) ? to ensure those customers are retained. That doesn't mean ignoring the useful many ? they are important too, but it shows where to focus.
•  approximately 20% of processes, assembly lines or machines will account for around 80% of defects.
•  about 20% of a business's products will account for 80% of its sales.