Binning based on equal distribution

Question

Hi all,

I'm trying to find an optimal tool to try and Bin a number of records into say 5 or 10 group of equal records.  I feel the Tile tool is only able to bin into 3 groups based on the standard deviation.

For example say I have a dataset that is items sold:

RecordIDItems Sold1102537445561788997109118127137142152167173185196201213

I want to find out what range I should set to say have 3 groups with a equal count in each group (in this case 7 records in each group).  Is there a certain tool that would be able to auto-calculate that?

Thanks!

mceleavey · Answer

Hi @whitkrieng ,

you may be talking about the multi-field binning tool. I've built an example around a 7 group distribution based on Items sold:

I've attached the build and you can mess around with the configuration of the binning tool.

Hope this helps,

M.

mceleavey_binning.yxmd

whitkrieng · Answer

Thanks for your response, I think the Equal Records clusters it randomly.  So in my instance, I want an algorithmic way to group the "Items Sold" in 3 buckets determined by the distribution of the "Items Sold".  If say there are 7 records for 1,2, and 3 # of "Items Sold" then I would construct a bucket of "1-3 Items Sold". Then the next bucket could "4-5 Items Sold" and last "6-10 Items" Sold.

Garabujo7 · Answer

Hello @whitkrieng ,

Have you tried the tile tool with the Equal Records Method?

I got three groups with 7 records each:

Gabriel

Tile equal records.yxmd