|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)
|* 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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top