Originally Posted by
rake922
I forget how to do this...
Let's say there's a 33.333% chance of team A winning
With that above statement
What's the probability of them winning ...
A. 7 of 15 times
B. 8 of 15 times
C. 9 of 15 times
D. 10 of 15 times
What's the probability of them losing:
E. 13 of 15 times
F. 12 of 15 times
In Excel, the probabilities of the team in question winning or losing exactly the number of times specified:
- =BINOMDIST(7, 15, 33.333%, 0)
- =BINOMDIST(8, 15, 33.333%, 0)
- =BINOMDIST(9, 15, 33.333%, 0)
- =BINOMDIST(10, 15, 33.333%, 0)
- =BINOMDIST(13, 15, 66.667%, 0)
- =BINOMDIST(12, 15, 66.667%, 0)
In general the probability of winning exactly W games out of N given a single-game win probability of p is:
=BINOMDIST(W, N, p, 0)
And the probability of winning at least W games out of N given a single-game win probability of p is:
=1-BINOMDIST(W-1, N, p, 1)