Difference between revisions of "Manuals/calci/BINOMDIST"
Jump to navigation
Jump to search
'
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">BINOMDIST (ns, t, ps, c)</font></font> <font size="3"><font face="Time...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''BINOMDIST (ns, t, ps, c)'''</div><br/> |
| − | + | 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: | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<font size="3"><font face="Times New Roman"> where: </font></font><font size="3"><font face="Times New Roman"> is COMBIN(n,x).</font></font> | <font size="3"><font face="Times New Roman"> where: </font></font><font size="3"><font face="Times New Roman"> is COMBIN(n,x).</font></font> | ||
Revision as of 03:16, 11 November 2013
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