lazy man random results
August 31st, 2014 at 11:23:28 AM
permalink
found this a while back so might help others
here is a quick way to get 1000's of results in excel very quick based on knowing the probabilities..
lets say you want to get craps dont pass results
column a bet column b prob column b lookup
dont pass winner = .4793 0
dont pass loser = .4929 =b1
dont pass push = .0278 =b1+b2
=LOOKUP(RAND(),$C$1:$C$3,$A$1:$A$3)
here is a quick way to get 1000's of results in excel very quick based on knowing the probabilities..
lets say you want to get craps dont pass results
column a bet column b prob column b lookup
dont pass winner = .4793 0
dont pass loser = .4929 =b1
dont pass push = .0278 =b1+b2
=LOOKUP(RAND(),$C$1:$C$3,$A$1:$A$3)
