CRITBINOM
Syntax:
CRITBINOM ( number-trials , success-probability , alpha )
Description: Computes the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
Arguments:
Name |
Type |
Description |
|---|---|---|
number-trials |
number |
The number of Bernoulli trials. |
success-probability |
number |
The probability of success on each trial. |
alpha |
number |
The criterion value. |
Return Type and Value: number – The smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
However, if
number-trials < 0,
#NUM!is returned.success-probability is < 0 or success-probability > 1,
#NUM!is returned.alpha < 0 or alpha > 1,
#NUM!is returned.
example: