Frequently Asked Questions
What does the BINOM.INV function do?
The BINOM.INV function calculates the smallest number of successes (k) for which the cumulative binomial distribution is greater than or equal to a specified criteria (alpha), given a fixed number of trials (n) and the probability of success (p) on each trial.
What are the required arguments for the BINOM.INV function?
The BINOM.INV function requires three arguments: the number of trials ("trials"), the probability of success on each trial ("probability_s"), and the criteria for the cumulative binomial distribution ("alpha").
What type of distribution does the BINOM.INV function use?
The BINOM.INV function uses the binomial distribution, which is a discrete probability distribution that models the number of successes in a fixed number of independent trials, each with the same probability of success.
Can BINOM.INV return an error?
Yes, BINOM.INV can return a #NUM! error if the "trials" argument is not a whole number (integer), if the "probability_s" argument is not between 0 and 1 (inclusive), or if the "alpha" argument is not between 0 and 1 (inclusive).
What is the difference between BINOM.INV and BINOM.DIST?
While BINOM.INV calculates the smallest number of successes (k) that satisfies a specified criteria for the cumulative binomial distribution, BINOM.DIST calculates the probability of achieving a specific number of successes (k) in a given number of trials (n) using the binomial distribution. BINOM.DIST can calculate both the individual probability (when "cumulative" is FALSE) and the cumulative probability (when "cumulative" is TRUE).