Excel Pareto Add-In

Share Now

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

Share Now
November 15, 2019

0 responses on "Excel Pareto Add-In"

    Leave a Message

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

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


    0124- 4601426


    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED