Manuals/calci/CRITBINOM

CRITBINOM(ts,ps,alpha)

• $ts$ is the number of independent trials.
• $ps$ is the probability of success in one trial.
• $alpha$ is the criterion value.

Description

• This function gives the smallest value for which the Cumulative Binomial Distribution is a specified probability.
• This function is the inverse of the Cumulative Binomial Distribution.
• For example, the Critbinom function could be used to find the smallest number of through the dice for which there is a 40% chance of at least 10 six's.
• In CRITBINOM(ts,ps,alpha), $ts$ is the number of independent trials that are to be done (if $ts$ value is in decimal then it is converted to an integer), $ps$ is the probability of success in one trial and $alpha$ is the criterion value of the Cumulative Binomial Distribution (must be between 0 and 1).
• This function gives the result as error when

1.Any one of the argument is non-numeric.
2.$ts<0$,or $ps<0$ or $ps>1$
3.$alpha<0$ or $alpha>1$

Examples

1. CRITBINOM(5,0.6,0.4) = 3
2. CRITBINOM(8,0.1,0.25) = 1
3. CRITBINOM(20,0.75,0.65) = 16
4. CRITBINOM(20,1,1.5) = NAN
5. CRITBINOM(9.5,0.4,0.35) = 3
6. CRITBINOM(12,-0.25,0.3) = NAN

See Also

• BINOMDIST
• NEGBINOMDIST
• COMBIN
• FACT

References

Correlation