How would you like to decile? Equal buckets (i.e. each decile has 1,000 accounts)? Or equal value (i.e. each decile has a market value of $100MM, so that there are tons of accounts in decile 1 and a handful of decile 10 powerhouses)?
Deciles: "Rank" data into ten groups of equal frequencies.
So Sort the data. Then: count the number of data items, divide that number by 10. Next group the sorted data into another location based on the count divided by 10. Do this nine more times to get a total of ten location groups of sorted data each containing about the same number of data elements.
Here is a prior post that i started with:
[post]281553 [/post]
Data is in col A, Excel's rank function is in col B and in col C is the rank value/divided by the max value in col B. This will make the excel rank standard. Does anyone know to automate the bin values so i can apply a similar approach to the Barry Katcher's link above?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.