Posting as :
works at
You are currently posting as works at

## Do you want the technical method or the shortcut method? Shortcut method is pretty easy just organize the % of totals from highest to lowest.Technical:The CDF of a single parameter pareto is F(x) = 1 - (theta/X)^alpha ; x>thetaTo find alpha the mean of your data = (a*theta)/(a-1)The variance of your data is = (a*theta^2)/(a-2) - (a^2*theta^2)/(a-1)^2Find alpha/theta and then model it to your data. And solve for X when F(x) =0.8

As a note, your data has to physically resemble a pareto or this may not work. For instanced if your data is uniform it probably wont work.

## Additional Posts in Excel Genius

Change my mind

### New to Fishbowl?

unlock all discussions on Fishbowl.
That was just a preview…
• Discover what it’s like to work at companies from real professionals
• Get candid advice from people in your field in a safe space
• Chat and network with other professionals in your field

Share

#### Embed this post

Copy and paste embed code on your site

Preview

See what’s happening in your industry
from the palm of your hand.