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.
