I am trying to simulate the results of 120 consecutive roulette wheel spins.
There are 36 numbers on a roulette table, plus a "0" and a "00". So,
inherently, a 1/38 chance that any given number will be the result of a spin.
I set the Random Number Generator to "Bernoulli" and a p-value of ".5" to
get the odds of a black v. red result, but this is not accurate because of
the "0" and "00" on the wheel. If anyone knows how to ask excel to randomly
generate 38 different potential results, please email me back. Also, I would
need a formula to translate each number to its corresponding color. I don't
know if an "IF" statement would work here, or what is best, but I am
interested to hear the thoughts of experts.