The BINOM.INV function returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

BINOM.INV takes 3 required arguments and no optional arguments:

Syntax: BINOM.INV(trials, probability_s, alpha)

#1)
Using the BINOM.INV function:
#2)
The arguments for the BINOM.INV function are:
Argument Required? Description
trials Required The number of Bernoulli trials.
probability_s Required The probability of a success on each trial.
alpha Required The criterion value.
#3)
A few more things:
If any argument is nonnumeric, BINOM.INV returns the #VALUE! error value.
If trials is not an integer, it is truncated.
If trials < 0, BINOM.INV returns the #NUM! error value.
If probability_s < 0 or probability_s > 1, BINOM.INV returns the #NUM! error value.
If alpha < 0 or alpha > 1, BINOM.INV returns the #NUM! error value.

Summary

The BINOM.INV function returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
comments powered by Disqus