Tech Support Guy banner
Status
Not open for further replies.

Excel Random Numbers

703 views 0 replies 1 participant last post by  nohooo 
#1 ·
I'm currently having a problem regarding random number generating, as I can't seem to find the answer anywhere. Anyway, my problem is that I am generating random numbers from 1 to 55, however, the probability of each number being chosen is already given. I know that if you use randbetween function, that the probability of all numbers being picked out is equal (in this case, each number has 1/55 chance of being picked). My problem is that I am already assigned some probability for each number to occur (like 5% for 1, 7% for 2, 25% for 3, 2% for 4, and so on...), and the random number generation should be based on that list of probabilities given to me. How do I do that?

Please do forgive me as I am an excel newbie, and I have utterly no idea what I'm supposed to do next.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top