Quote:
Originally Posted by imofe
What would be the correct way to calculate probable max losses in a row at a 45% winning clip over 1000 trials?
|
I'm going to have think more about the subject to really give you any info weighing the pros and cons of drop down formulas and other options, but here is a quick answer:
1000 trials = a maximum of 12 consecutive losses
10000 trials = a maximum of 15 consecutive losses
formula for excel "=ROUND(LN(
1000)/-LN((1-
A1)),0)" where A1 is "x" or whatever cell you have the win% and "1000" is the number of trials.