Slot Math - Scatter(2)

 

When we calculate the event numbers of scatter landing on the reel, we need to list all possibilities, which increase the chance that calculate error. Actually, there is a much more easier way to calculate the hit frequency of free game, and all it need is that the landing chance of scatters are same in all reels it may land

Using this method, we need to use BINOM.DIST or BINOM.DIST.RANGE function in excel. Those two functions can return the individual term binomial distribution probability. So, when all reels that have scatter symbols have the same chance that scatters landing on the reels, you can simply use one of those two function to get the hit frequency of free game

Syntax of those two functions

To be more specific, using the example in last article, there are 16 symbols in each reels and all reels have only one scatter, which means the landing chance of scatter symbols in those reels are same。 We can use BINOM.DIST function to get the probabilities of each events

Comparing to the result we get by listing all events in last article, you can easily find their results are same

BINOM.DIST or BINOM.DIST.RANGE function can have a vary use in modeling process of slot, especially in video games

Post a Comment

0 Comments