BINOMDIST
Syntax:
BINOMDIST ( number-successes , number-trials , success-probability , cumulative-flag )
Description: Computes the individual term binomial distribution probability.
Mathematical Formula:
The binomial probability mass function is:
where:
is COMBIN(n,x)
.
The cumulative binomial distribution is:
Arguments:
Name |
Type |
Description |
---|---|---|
number-successes |
number |
The number of successes in number-trials, truncated to an integer. |
number-trials |
number |
The number of independent trials, truncated to an integer. |
success-probability |
number |
The probability of success on each trial. |
cumulative-flag |
logical |
Determines the form of the function. If |
Return Type and Value: number – The individual term binomial distribution probability.
However, if
number-successes < 0 or number-successes > number-trials,
#NUM!
is returned.success-probability < 0 or success-probability > 1,
#NUM!
is returned.