# BINOMDIST

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_s The number of successes out of the "trials". trials The number of independent trials. probability_s The probability of a success on each trial. cumulative A logical value indicating the 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.microsoft.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!