Hi, this question would be quite similar to the one already asked here.
I would like to randomly choose a number from the following set (0,1) i.e. either a 0 or a 1, but with the following probabilities assigned:
0 - 20%
1 - 80%
I had a look at the above mentioned thread and following is what I could come up with:
=CHOOSE(MATCH(RAND(); {0;0,8}); RANDBETWEEN(0;1))
This certainly produces incorrect results. Where am I going wrong?
Bookmarks