©Pareto-Ultimate

The ultimate Pareto analysis utility within Excel

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

Therefore, many businesses have easy access to dramatic improvements in profitability by focusing on the most effective areas and eliminating, ignoring, automating, delegating, or retraining the rest, as appropriate.

What makes Pareto-Ultimate© apart is that it works directly on the raw database and not like some other add-ons, on summarized data. As it focuses on Pareto and is not a marginal feature of some more sophisticated software,  It takes the 20/80 analysis to a completely new level.

It features a wealth of features, some of them proprietary ones such as the Pareto Strength Index© which indicates at a glance the degree to which the data fit the Pareto paradigm.

MAIN FEATURES

  • Makes the analysis directly from the raw database which may consist of thousands of observations

  • Can breakdown the analysis by a secondary variable with a complete drill-down capability
     

  • May refer to a 3rd continuous variable to make the analysis refer to the sum or other stats, rather than the number of occurrences

  • Performs a full ABC analysis

  • Features a very powerful crosstabulation module making it even more potent than Excel Pivot table

  • Enables complete control of the categories to include in the analysis

  • Allows to export the analysis to Excel both in tabular and graphical format

  • The analysis may be performed on a subset of the whole data

Get In Touch