|BINOM.INV(trials, probability_s, alpha)|
Returns the number of trials needed for a specific amount of success using a binomial distribution.
|trials||The total number of trials.|
|probability_s||The probability of a success on each trial.|
|alpha||The cumulative probability you want to find.|
|* This function was added in Excel 2010 to replace the CRITBINOM function.|
* For an illustrated example refer to the page under [[Distributions]]
* The binomial distribution is a [[discrete distribution]]
* This function will return the smallest number of trials needed for which the cumulative distribution is greater than or equal to "alpha".
* If any of the arguments are not numeric, then #VALUE! is returned.
* If "trials" is not an integer, it will be truncated.
* If "trials" < 0, then #NUM! is returned.
* If "probability_s" < 0, then #NUM! is returned.
* If "probability_s" > 1, then #NUM! is returned.
* If "alpha" < 0, then #NUM! is returned.
* If "alpha" > 1, then #MUM! is returned.
* You can use the BINOM.DIST function to return the probability of getting a specific number of successes using a binomial distribution.
* You can use the BINOM.DIST.RANGE function to
* You can use the NEGBINOM.DIST function to
* For the Microsoft documentation refer to support.microsoft.com
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top