BINOM.DIST.RANGE |
BINOM.DIST.RANGE(trials, probability_s, number_s [,number_s2]) |
Returns the probability of a trial result using a binomial distribution. |
trials | The number of independent trials. |
probability_s | The probability of success in each trial. |
number_s | The number of successes in trials. |
number_s2 | (Optional) The upper value for a number of successes, between "number_s" and "number_s2". |
REMARKS |
* For an illustrated example refer to the page under [[Distributions]] * BINOM.DIST.RANGE(n, p, x, y) = the probability there are between x and y successes (inclusive) in n trials where the probability of success on any trial is p * BINOM.DIST.RANGE(n, p, x, y) = BINOMDIST(y, n, p, TRUE) - BINOMDIST(x-1, n, p, TRUE) if x > 0 * BINOM.DIST.RANGE(n, p, 0, y) = BINOMDIST(y, n, p, TRUE). * BINOM.DIST.RANGE(n, p, x) = BINOMDIST(x, n, p, FALSE). * If "trials" < 0, then #NUM is returned. * If "numbers" < 0, then #NUM is returned. * If "numbers_s" > "trials", then #NUM is returned. * If "trials" is not numeric, then #VALUE is returned. * If "probability_s" is not numeric, then #VALUE is returned. * If "number_s" is not numeric, then #VALUE is returned. * If "number_s2" is not numeric, then #VALUE is returned. * If "number_s2" is left blank, then ?? * If "number_s2" < "number_s", then #NUM is returned * If "number_s2" > "trials", then #NUM is returned. * You can use the BINOM.DIST function to return the probability of getting a particular value using a binomial distribution. * You can use the BINOM.INV function to return the probability of getting (greater than) a particular value 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 2013. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top