Excel Pareto Add-In

What is Pareto Analysis?

The Pareto principle (also known as the 80/20 rule, the law of the vital few, or the principle of factor sparsity) states that, for many events, roughly 80% of the effects come from 20% of the causes.

Pareto analysis is a formal technique useful where many possible courses of action are competing for attention. In essence, the problem-solver estimates the benefit delivered by each action, then selects a number of the most effective actions that deliver a total benefit reasonably close to the maximal possible one. – Source “Wikipedia”

Some of the area’s where we can use Pareto principle

  • 80% of complaints we can resolve by working on 20% of issues
  • 80% of Sales in business by 20% of customers
  • 80% profit in business by 20% of customers
  • 80% of sales by 20% of sales peoples

This customized Pareto Add-in you can use on any dataset.

Step’s to install Add-In

  • First, save Add-In file in your Microsoft Add-In repository.
  • Now Activate your Add-In
  • To Activate click File Tab > Options > Add-Ins
  • Then from Inactive select, your add-in and hit go button.
  • In Popup box select Add-in and click ok

Now Assign Add-in to Ribbon

  • Click file tab > options > Customize Ribbon
  • Click New Tab > New Group
  • Select Macro in the choose commands from drop-box
  • Now assign your macro to ribbon

This Add-in holds three input controls

  1. Categorical Variable
  2. Variable hold values

Location where you want to create Pareto chart

Entire Code of Add-in:

Download Pareto Add-In

October 28, 2017

0 Responses on Excel Pareto Add-In"

Leave a Message

Your email address will not be published. Required fields are marked *

© copyright www.excelcrazy.com. All rights reserved. Design and Development by www.creativebrainweb.com