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

Please solve The Super Hero slot machine has three wheels that spin

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!