BINOMDIST(number_s, trials, probability_s, cumulative)

Returns the probability of getting less than or equal to a particular value in a binomial distribution.

number_sThe number of successes out of the "trials".
trialsThe number of independent trials.
probability_sThe probability of a success on each trial.
cumulativeThe type of function to use:
True = cumulative probability function (less than)
False = probability mass function (equal to)

Remarks

* BINOM.DIST was added in Excel 2010 to replace this function.
* The binomial distribution is a discrete distribution.
* If "cumulative" = True (or not zero), then the area under the curve to the left of "x" is returned. This uses the cumulative probability function.
* If "cumulative" = False (or zero), then the height of the bell shaped curve at "x" is returned. This uses the probability mass function.
* The "number_s" and "trials" are truncated to integers.
* If "number_s" is not numeric, then #VALUE! is returned.
* If "number_s" < 0, then #NUM! is returned.
* If "number_s" > "trials", then #NUM! is returned.
* If "trials" is not numeric, then #VALUE! is returned.
* If "probability_s" < 0, then #NUM! is returned.
* If "probability_s" > 1, then #NUM! is returned.
* If "probability_s" is not numeric, then #VALUE! is returned.
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

 A
1=BINOMDIST(1,6,0.5,FALSE) = 9.38%
2=BINOMDIST(2,6,0.5,FALSE) = 23.44%
3=BINOMDIST(3,6,0.5,FALSE) = 31.25%
4=BINOMDIST(4,6,0.5,FALSE) = 23.44%
5=BINOMDIST(5,6,0.5,FALSE) = 9.38%
6=BINOMDIST(6,6,0.5,FALSE) = 1.56%
7=BINOMDIST(1,6,0.5,TRUE) = 10.94%
8=BINOMDIST(2,6,0.5,TRUE) = 34.38%
9=BINOMDIST(3,6,0.5,TRUE) = 65.63%
10=BINOMDIST(4,6,0.5,TRUE) = 89.06%
11=BINOMDIST(5,6,0.5,TRUE) = 98.44%
12=BINOMDIST(6,6,0.5,TRUE) = 100.00%
13=BINOMDIST(6,10,-0.5,FALSE) = #NUM!
14=BINOMDIST(6,"some text",0.5,FALSE) = #VALUE!


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