BINOM.INV function
The BINOM.INV 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 a criterion value.
Syntax
BINOM.INV(trials, probability_s, alpha)
The BINOM.INV function has the following arguments:
| Argument | Description |
|---|---|
| trials | The number of trials, a numeric value greater than 0. |
| probability_s | The success probability of each trial, a numeric value greater than 0 but less than 1. |
| alpha | The criterion, a numeric value greater than 0 but less than 1. |
Notes
How to apply the BINOM.INV function.
Examples
The figure below displays the result returned by the BINOM.INV function.
