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

* Added in Excel 2013.
* 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" < "number_s", then #NUM is returned
* If "number_s2" > "trials", then #NUM is returned.
* For the Microsoft documentation refer to support.office.com

 A
1??


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