Are you already bored of these functions? This function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. This may seem silly, but it is useful for creating standalone simulation analysis in Excel (see Simulation stimulation for more information).
The BINOM.INV The function uses the following syntax to operate:
BINOM.INV (essays, probability_s, alfa)
The BINOM.INV The function has the following arguments:
- essays: this is necessary and represents the number of Bernoulli trials
- probability_s: this is also necessary. This is the probability of success in each test.
- alfa: again, required. This represents the previously mentioned criterion value.
It should be noted at the same time that:
- if any argument is not numeric, BINOM.INV return the #VALUE! error value
- And trials it is not a whole number, is truncated
- And trials <0, BINOM.INV return the #ON ONE! error value
- And probability_s it is <0 O probability_s > 1, BINOM.INV return the #ON ONE! error value
- And alfa <0 O alfa > 1, BINOM.INV return the #ON ONE! error value.
Please, see my example below: