BINOM.INV
Formulas / BINOM.INVThe 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.
=BINOM.INV(trials, probability_s, alpha)
- trials - The number of independent trials.
- probability_s - The probability of success on each trial.
- alpha - The criteria for the cumulative binomial distribution.
Examples
-
In the following format:
The AND function returns TRUE if all of the arguments evaluate to TRUE. If any argument evaluates to FALSE, AND will return FALSE.
Yes, AND can be used with other logical functions. This can expand the usefulness of those logical functions.
AND returns a #VALUE! error if the arguments contain no logical values.
Yes, AND ignores both text cells and blank cells.
can you give me the faqs for the formula BINOM.INV
Need help with Formulas?
Summary
The BINOM.INV function in Excel calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria, given a fixed number of trials and the probability of success on each trial.
- The BINOM.INV function calculates the smallest number of successes (k) that satisfies a specified criteria for the cumulative binomial distribution, given a fixed number of trials (n) and the probability of success (p) on each trial.
- 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").
- The BINOM.INV function 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).
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).
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV