Difference between revisions of "Manuals/calci/BINOMIALDISTRIBUTED"
Jump to navigation
Jump to search
Line 13: | Line 13: | ||
==Examples== | ==Examples== | ||
− | #BINOMIALDISTRIBUTED(10,0.4) = | + | #BINOMIALDISTRIBUTED(10,0.4) = 36 42 45 41 41 38 37 36 32 41 |
==See Also== | ==See Also== |
Revision as of 15:15, 1 March 2018
BINOMIALDISTRIBUTED (Numbers,Probability)
- is the number of variables.
- is the value from 0 to 1.
Description
- This function gives the value of the Binomial distribution.
- In , is the number of the variables and is the probability value which varies from 0 to 1.
- This gives the discrete probability distribution.
- The probability of getting exactly k successes in n trials is given by the Probability Mass Function:
for k=0,1,2,3...n where is the COMBIN(n,k) i.e.
- The Cumulative Binomial Distribution is:.
Examples
- BINOMIALDISTRIBUTED(10,0.4) = 36 42 45 41 41 38 37 36 32 41
See Also
References