Manuals/calci/BINOMDIST
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:
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 4 | 12 | 0.3 | FALSE |
| Row2 | 0.2311 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |