Spread Formula Reference
CRITBINOM
Formula Functions > Functions A to C > CRITBINOM

This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Syntax

CRITBINOM(n,p,alpha)

Arguments

This function has these arguments:

Argument Description
n Number of trials; if not an integer, the number is truncated
p Probability of success on each trial; number between 0 and 1
alpha Alpha, value for the criterion

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

CRITBINOM(B5,0.75,0.92)

CRITBINOM(R5C2,R8C14,0.75)

CRITBINOM(14,0.75,0.85) gives the result 12

Version Available

This function is available in product version 1.0 or later.

See Also

BINOMDIST | Statistical Functions