Question: The Super Cherry slot machine has three wheels that spin independently when the handle is pulled. For each wheel the probabilities are 20% that a
The Super Cherry slot machine has three wheels that spin independently when the handle is pulled. For each wheel the probabilities are 20% that a Cherry will appear, 30% that a Plum will appear, 25% that an Ace will appear, and 25% that a Seven will appear. For each pull of the handle you put a bet of $1. If you get three Cherries, you win your bet back plus $25. If you get two Cherries, you get your bet back plus $2. If you get one Cherry, you just get your $1 bet back. Otherwise you lose your bet of $1. You start with a stake of $100.
Create an excel worksheet to simulate a session of 100 spins. You should have 100 rows, one for each spin. You should have columns at least for the 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.
Please show me a screenshot of your excel solution. Thanks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
