lundi 23 novembre 2015

How to Generate Random Values in Excel (Multinomial?)

So I have 4 groups with individual proportions p1, p2, p3, p4. Taking a random sample from this, the sum of the 4 values should equal 20 for each generation. I have seen how to create 4 random values that sum to a number, but how do I factor in that they have these initial probabilities of being chosen?




Aucun commentaire:

Enregistrer un commentaire