For the probability of x or less wins, use a 1. Use a 0 in the fourth position of the function for the exactly probability of x wins. P=probability of success in any given trial. Tt has also been reported that red came up 39 times in a row in the Casino Monte Carlo, Monaco. The probability of this happening on a European Roulette table is (18/37) to the power of 32 which comes to 1 in 10,321,314,387. According to the binomial distribution, the probability is (18/38) 60 * (20/38) 40 * combin(100,60) = 0.003291.Įxcel also has a function for the binomial distribution. The record for the number of reds in a row was set in the US in 1943 when the colour came up 32 times in a row.

For example, suppose you want to know the probability that in 100 spins of a roulette wheel the number of reds will be exactly 60. The combin function is explained in my glossary. Therefore if we take the formula and apply it, we will have the following equation: (19/18 1/1) 18/37 100 0.027027027. Specifically if the probability of each success is p, the number of success is s, and the number of trials is n then the probability of s successes is p s * (1-p) n-s * combin(n,s). In order to calculate the house edge, we will apply the following formula: (Odds Against Winning House Odds) Probability of Winning 100 house edge percentage. Briefly, the binomial distribution is the probability that any given number of events will happen given a specific probability for each event and a specific number of trials. Any introductory probability and statistics book should give good treatment to the binomial distribution.

Roulette odds 8 teds in a row