BINOM.INV |
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. |
REMARKS |
* 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 return the probability of a trial result using a binomial distribution. * You can use the NEGBINOM.DIST function to return the probability distribution function OR the cumulative probability function for a negative binomial distribution. * This function was added in Excel 2010 to replace the CRITBINOM function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top