# BINOMDIST

BINOMDIST(number_s, trials, probability_s, cumulative)

Returns the probability of getting a specific number of successes using a binomial distribution.

 number_s The number of successes. trials The total number of trials. probability_s The probability of a success on each trial. cumulative A logical value indicating the type of function to use:False (or 0) = [[probability distribution function]] (equal to)True (<> 0) = [[cumulative probability function]] (equal to or less than)

 REMARKS
 * BINOM.DIST was added in Excel 2010 to replace this function.* The binomial distribution is a [[discrete distribution]]* If any of the arguments are not numeric, then #VALUE! is returned.* The "number_s" and "trials" are truncated to integers.* If "number_s" < 0, then #NUM! is returned.* If "number_s" > "trials", then #NUM! is returned.* If "probability_s" < 0, then #NUM! is returned.* If "probability_s" > 1, then #NUM! is returned.* If "cumulative" = False, then the height of the curve at "x" is returned.* If "cumulative" = True, then the area under the curve to the left of "x" is returned.* 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 BINOM.DIST.RANGE function to * You can use the NEGBINOM.DIST function to* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.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!