Calculates the Binomial Distribution Cumulative Distribution Function.
Formula: binomdist(sccs, trials, prob, 1)
cdf: The result of the formula. 0<= cdf <=1
sccs: The number of successful trials. Only the integer part is used. 0 <= sccs <= trials.
trials: The total number of trials. Only the integer part is used. 0 <= trials
prob: The probability of success for each trial. 0<= prob <=1
Sports team A has a 0.6 probability of beating team B in any given game. If they play 4 games, what is the probability of team A winning 0,1 or 2 of the 4 games?
Value | Keystrokes | Display | Description |
---|---|---|---|
2 | sccs | 2.0000 | Stores the sccs value. |
4 | trials | 4.0000 | Stores the trials value. |
.6 | prob | 0.6000 | Stores the prob value. |
cdf | 0.5248 | Calculates the cdf. |
In order for team A to have a .1 cdf of winning 0, 1 or 2 of 4 games, what is the required probability of winning an individual game?
These keystrokes assume the values from example 1.
Value | Keystrokes | Display | Description |
---|---|---|---|
.1 | cdf | 0.1000 | Stores the cdf value. |
prob | 0.8574 | Calculates the prob value. |
With a 0.8574 probability of winning each game, there is only a .1 probability of winning 0, 1 or 2 games. So there is a .9 probability that team A will win 3 or 4 or the 4 games.
Reference:
Binomial Distribution - Wikipedia