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 *

    Tableau Training in Delhi

    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.

    Address

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    Featured Testimonial

    The experience...Read more

    Karan Jeena (HR Analyst)

    ZS Associates

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED