CRITBINOM Function

The CRITBINOM function is one of the statistical functions. It is used to return the smallest value for which the cumulative binomial distribution is greater than or equal to the specified alpha value.

Syntax

CRITBINOM(trials, probability_s, alpha)

The CRITBINOM function has the following arguments:

Argument	Description
trials	The number of trials, a numeric value greater than or equal to 0.
probability_s	The success probability of each trial, a numeric value greater than or equal to 0 but less than or equal to 1.
alpha	The criterion, a numeric value greater than or equal to 0 but less than or equal to 1.

Notes

How to apply the CRITBINOM function.

Examples

The figure below displays the result returned by the CRITBINOM function.