Question: Please solve The Super Hero slot machine has three wheels that spin independently when the handle is pulled. For each wheel the probabilities are 20%
Please solve

The Super Hero slot machine has three wheels that spin independently when the handle is pulled. For each wheel the probabilities are 20% that a Superman will appear, 50% that a Spiderman will appear, and 30% that a Batman will appear. For each pull of the handle you put a bet of S1. If you get three Superman, you win your bet back plus $30. If you get two Superman, you get your bet back plus $5. If you et one Superman, you just get your 1 bet back. Otherwise you lose your bet of 51. You start with a stake of 5100. Create a worksheet to simulate a session of 100 spins. You should have 100 rows, one for each spin. You should have columns at least forthe spin number (1 through 100), each of the three wheels, the amount you win or lose on the spin, and the amount of money you have at the end of the spin. Each time you press F9 (recalculate) you should get a different set of spins and results according to the above probabilities
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
