The number of games with crashpoint >= 2.06 in a total of 1686 games should follow a binomial distribution of N = 1686 and p = 47.814538%. So the chance to have less than or equal to 777 wins is 0.081149924, which is very close to the number dooglus obtained by simulation.
An easy way to calculate it is to use "=BINOMDIST(777, 1686, 47.814538%, 1)" in Excel.
This is a pretty cool function I wasn't aware of. So if we wanted to see the chance of 35 losses in a row at 49.5%, would that be:
"=BINOMDIST(35, 35, 49.5%, 1)"
?
When the last field is "1", it is to calculate the CDF. And when the last field is "0", it is to calculate the PDF.
If you want to see the chance of having
exactly 30 wins in 35 bets at 49.5%, you can use "=BINOMDIST(30, 35, 49.5%,
0)" and will get 0.000735%.
If you want to see the chance of having
exactly 35 wins in 35 bets at 49.5%, you can use "=BINOMDIST(35, 35, 49.5%,
0)" and will get 0.0000000020473% which is exactly 0.495^35.
If you want to see the chance of having
less than or equal to 10 wins in 35 bets, you can use "=BINOMDIST(10, 35, 49.5%,
1)" and will get 0.976982%.
Edit: Fixed typos.