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?
|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.
|.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.