Compatibility - CRITBINOM Function
The CRITBINOM function replaces the BINOM.INV function in Excel 2010.
Description
The function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Use this function for quality assurance applications.
Syntax
CRITBINOM (trials,probability_s,alpha)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Trials | The number of Bernoulli trials. | Required |
Probability_s | The probability of a success on each trial. | Required |
Alpha | The criterion value. | Required |
Notes
If trials is not an integer, it is truncated.
If any argument is nonnumeric, CRITBINOM returns the #VALUE! error value.
If trials < 0, CRITBINOM returns the #NUM! error value.
If probability_s is < 0 or probability_s > 1, CRITBINOM returns the #NUM! error value.
If alpha < 0 or alpha > 1, CRITBINOM returns the #NUM! error value.