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:

CRITBINOM(6,0.5,0.75) results in 4
CRITBINOM(12,0.3,0.95) results in 6

end example]