Hi All,
Im new so please be gentle
Im trying to work out the probability of a slot bonus.
There is 20 boxes containing randomly seeded and hidden.
Assuming it dont cheat and using the values below im trying to work out the probability of getting each colour.
3 x BLUE
4 x PURPLE
5 x ORANGE
8 x GREEN
The player picks until 3 the same are revealed and then wins that colour.
So far I have worked out that there is only 27 outcomes for each colour due to the order isnt strictly relevent.
eg
BBOOPGGG is same as if it had been BOGOPBGG = same result GREEN AWARDED
so 4 colours = 108 actual outcomes to work out.
Im also assuming that each one of the 108 can be worked out to get an overall break down.
But this is where im getting stuck
im using the combin function in excel like this :-
BBPOOGGG
=COMBIN(3,2)*COMBIN(4,1)*COMBIN(5,2)*COMBIN(8,3)/COMBIN(20,8)/COMBIN(8,1)
= 0.006668254
but after working out the other 107 it is higher than 1 which isnt right! as of course they should all add to 1
Anyone know what im missing / doing wrong ?
Regards,
Steve.
Im new so please be gentle
Im trying to work out the probability of a slot bonus.
There is 20 boxes containing randomly seeded and hidden.
Assuming it dont cheat and using the values below im trying to work out the probability of getting each colour.
3 x BLUE
4 x PURPLE
5 x ORANGE
8 x GREEN
The player picks until 3 the same are revealed and then wins that colour.
So far I have worked out that there is only 27 outcomes for each colour due to the order isnt strictly relevent.
eg
BBOOPGGG is same as if it had been BOGOPBGG = same result GREEN AWARDED
so 4 colours = 108 actual outcomes to work out.
Im also assuming that each one of the 108 can be worked out to get an overall break down.
But this is where im getting stuck
im using the combin function in excel like this :-
BBPOOGGG
=COMBIN(3,2)*COMBIN(4,1)*COMBIN(5,2)*COMBIN(8,3)/COMBIN(20,8)/COMBIN(8,1)
= 0.006668254
but after working out the other 107 it is higher than 1 which isnt right! as of course they should all add to 1
Anyone know what im missing / doing wrong ?
Regards,
Steve.