BINOM.DIST.RANGE

BINOM.DIST.RANGE(trials, probability_s, number_s [,number_s2])

Returns the probability of a trial result using a binomial distribution.

trialsThe number of independent trials.
probability_sThe probability of success in each trial.
number_sThe 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

 A
1??


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top