Distribution of one number over different categories with specific probabilities per category
Hi all,
I’ve been trying to create a formula to distribute a given amount of points over multiple different categories with different probabilities for each individual category.
So for example 10 points over 6 different categories with 50% probability for each point to be added to category 1, 20% for category 2, 10% for categories 3 and 4, and 5% for categories 5 and 6.
I appreciate any ideas!
Hi all, I’ve been trying to create a formula to distribute a given amount of points over multiple different categories with different probabilities for each individual category.So for example 10 points over 6 different categories with 50% probability for each point to be added to category 1, 20% for category 2, 10% for categories 3 and 4, and 5% for categories 5 and 6. I appreciate any ideas! Read More