Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a distribution of numbers (population totals) across 295 zip codes. I
would like to identify the zip code total that represents the "80/20" break (the pareto principle - the assumption that 20% of the number zip codes contain 80% of the population of the region). I.e., I would like to enter a function that returns the zip code total that, above which, the zip code totals comprise 80% of the population. This will enable me to identify the number of zip codes that comprise 80% of the population, comparitively small, with a COUNTIF function. Is this possible. Thanks, DEI |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Page Break Preview from all spreadsheets | Excel Discussion (Misc queries) | |||
VBA Code | Excel Discussion (Misc queries) | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
shortening a forumula | Excel Discussion (Misc queries) | |||
content does not stay in page break | Excel Worksheet Functions |