How to simulate slot machines winnings on excel ? Randbetween or whatif function ??

[yys0501]

[TABLE="width: 574"]
<tbody>[TR]
[TD="class: xl65, width: 574"]Slot machine has three identical reels, each reel with spots for 64 images. These include cherry, plum, melon, ace, bar, bell, diamond, lemon, gold coins, orange, and seven. After inserting one or more dollar coins, the gambler pulls the handle and the reels spin. The machine displays three images, one from each reel, when the reels stop spinning. Depending on the counts of certain images displayed and the bet inserted, the machine gives in return nothing, some coins, or an overflowing payoff.

a. Construct a spreadsheet model to simulate the slot machine. Assume in each reel,
there are 4 cherry, 4 plum, 4 melon, 5 ace, 5 bar, 7 bell, 7 diamond, 7 lemon, 7 gold
coins, 7 orange and 7 seven images, all randomly arranged.
b. For every $1 inserted, the payoff for 1 cherry image is $2, 2 cherry images gives
$5, and 3 cherry images gives $10; 2 plum images gives $20, 3 plum images gives $30; and 2 melon images gives $40 and 3 melon images gives $60. What is the net balance after 28 pulls when the initial is $100 and bets are all $1 each?
c. How do you handle more complex payoff conditions? For example, a set of 1 gold coins, 1 diamond and 1 melon images to pay out $150 per dollar bet.



[/TD]
[/TR]
</tbody>[/TABLE]

 

[CodeNinja]

Is this your homework?

 

[MrTeeny]

Assign each of the images a number between 1-64 and use randbetween(1,64) to generate each of the 3 reels. A simple function can display the fruit or even tweak it to pull up an image

Public Function ReelImage(reelNumber As Single) As String    Select Case reelNumber
        Case 1 To 4
            ReelImage = "CHERRY"
        Case 5 To 8
            ReelImage = "PLUM"
        Case 9 To 12
            ReelImage = "MELON"
            
            'ETC ETC
        
            
        Case Else
            ReelImage = "SEVEN"
            
    End Select
End Function

=REELiMAGE(RANDBETWEEN(1,64))

will then display whatever fruit in a cell

The rest is just basic probabilities, you have 4 cherries in 64 images so the probability of a cherry in reel 1 is 4 in 64 i.e. 1 in 16 probability of cherry in reels 2 & also 1 in 16. Probability of a cherry in any line is 3 reels * 1/16 =3 *1/16. They'll be plenty of examples of how to calculate probabilities on the net , look for probabilities of rolling consecutive dice etc and look at how say situations of two cherries can occur cherry plum cherry, plum cherry cherry, cherry cherry plum so it's not simply 1/16*1/16

 

[Fluff]

Is this your homework?

Judging by this thread I guess the answer is yes
https://www.mrexcel.com/forum/excel...ng-rand-functions.html?highlight=slot+machine

 

[CodeNinja]

May I suggest we let these students learn themselves and not provide answers to their homework... If they get stuck, maybe a nudge, but not provide answers...

CN.

 

[Fluff]

May I suggest we let these students learn themselves and not provide answers to their homework... If they get stuck, maybe a nudge, but not provide answers...

CN.

I'm with you on that