The BINOM.INV function returns the inverse of the cumulative binomial distribution, i.e. for a given number of independent trials, the function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- BINOM.INV replaces the CRITBINOM function included in earlier versions of Excel.
|trials||The number of independent trials to be done|
|probability_s||The probability of a success on each trial|
|alpha||The criterion value – must be between 0 and 1|
|2||100||Number of Bernoulli trials|
|3||0.5||Probability of a success on each trial|
|7||=BINOM.INV(A2,A3,A4)||53||Smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the supplied arguments are nonnumeric|
|#NUM!||Occurs if either:
The Cumulative Binomial Distribution, calculated by the BINOM.DIST function, is a statistical measure that is frequently used to indicate the probability of obtaining a specific number of successes from a specific number of independent trials.
The BINOM.INV function calculates the inverse of the cumulative binomial distribution, i.e. for a given number of independent trials, the BINOM.INV function returns the smallest value of x, the number of successes, for a specified cumulative binomial distribution probability.
See Wikipedia for more information on binomial distribution.