A roullette wheel has 18 red, 18 black, and one zero slots. With each play of the game, a gambler bets $1 on red. Gambler’s initial capital is $10. A game is over when the gambler either wins $ 10 (his capital becomes $20) or becomes broke (capital = $0). Create a command button (B8) and assign it to a code to estimate the probability of becoming broke (D8). (use 10,000 simulation runs; you can use the VBA Rnd function as a random number generator) Run
EXPERT ANSWER the code is self explanatory 18 red balls 18 black balls 1 zero slot probability of red ball is 18/37 probability of black ball is 18/37 probability of zero slot is 1/37 generate a random number in 0 to 1 if the number lies between 0 and 18/37 , its a red ball, …