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: