BINOMDIST (ns, t, ps, c)
Where ns is the number of successes in trials.
t is the number of independent trials.
ps is the probability of success on each trial and c is a logical value that determines the form of the function. It calculates the individual term binomial distribution probability. ns and t are integers. When ns or t or ps is nonnumeric BINOMDIST displays error. When ns is less than 0 or greater than t, BINOMDIST shows NaN.
When ps is less than 0 or greater than 1, BINOMDIST calculates the wrong result.
Formula The binomial probability mass function is:
where: is COMBIN(n,x).
The cumulative binomial distribution is:
BINOMDIST
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 4 | 12 | 0.3 | FALSE |
| Row2 | 0.2311 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
i.e. = BINOMDIST (4, 12, 0.3, FALSE) is 0.2311