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