Difference between revisions of "Manuals/calci/BINOMDIST"
Jump to navigation
Jump to search
'
| Line 2: | Line 2: | ||
*ns is the number of successes in trials. | *ns is the number of successes in trials. | ||
| − | * | + | *ts 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. | *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. | *It calculates the individual term binomial distribution probability. | ||
Revision as of 03:32, 11 November 2013
BINOMDIST (ns, ts, ps, cu)
- ns is the number of successes in trials.
- ts 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