Difference between revisions of "Manuals/calci/POISSON"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''POISSON( | + | <div style="font-size:30px">'''POISSON(X,Lambda,Cumulative)'''</div><br/> |
*<math>x</math> is the number of events. | *<math>x</math> is the number of events. | ||
− | *<math> | + | *<math>Lambda </math> is the mean |
− | *<math> | + | *<math>Cumulative</math> is the logical value like TRUE or FALSE. |
==Description== | ==Description== | ||
Line 8: | Line 8: | ||
*The Poisson distribution is a discrete probability distribution for the counts of events that occur randomly in a given interval of time. | *The Poisson distribution is a discrete probability distribution for the counts of events that occur randomly in a given interval of time. | ||
*It is is used to model the number of events occurring within a given time interval. | *It is is used to model the number of events occurring within a given time interval. | ||
− | *In <math>POISSON( | + | *In <math>POISSON(X,Lambda,Cumulative)</math>, <math>X</math> is the number of events in a given interval of time, <math>Lambda </math> is the Average Numeric value and <math>Cumulative</math> is the logical value. |
*If it is TRUE, this function will give the Cumulative Poisson Probability with the number of random events between <math>0</math> and <math>x</math>(included). | *If it is TRUE, this function will give the Cumulative Poisson Probability with the number of random events between <math>0</math> and <math>x</math>(included). | ||
*If it is FALSE, this function will give the Poisson Probability Mass function with the number of events occurring will be exactly <math>x</math>. | *If it is FALSE, this function will give the Poisson Probability Mass function with the number of events occurring will be exactly <math>x</math>. | ||
Line 17: | Line 17: | ||
<math>F(k,\lambda)=\sum_{k=0}^x \frac{e^{-\lambda} .\lambda^k}{k!}</math>. | <math>F(k,\lambda)=\sum_{k=0}^x \frac{e^{-\lambda} .\lambda^k}{k!}</math>. | ||
*This function will return the result as error when | *This function will return the result as error when | ||
− | 1.<math> | + | 1.<math>X</math> or <math>Lamda</math> is non-numeric. |
− | 2.<math> | + | 2.<math>X<0</math> or <math>Lamda<0</math>. |
==Examples== | ==Examples== |
Revision as of 13:43, 15 December 2016
POISSON(X,Lambda,Cumulative)
- is the number of events.
- is the mean
- is the logical value like TRUE or FALSE.
Description
- This function gives the value of the Poisson distribution.
- The Poisson distribution is a discrete probability distribution for the counts of events that occur randomly in a given interval of time.
- It is is used to model the number of events occurring within a given time interval.
- In , is the number of events in a given interval of time, is the Average Numeric value and is the logical value.
- If it is TRUE, this function will give the Cumulative Poisson Probability with the number of random events between and (included).
- If it is FALSE, this function will give the Poisson Probability Mass function with the number of events occurring will be exactly .
- The probability mass function is:
where is the shape parameter and . is the base of the natural logarithm (e=2.718282).
- The Cumulative Poisson Probability function is:
.
- This function will return the result as error when
1. or is non-numeric. 2. or .
Examples
- POISSON(10,3,TRUE) = 0.9997076630493528
- POISSON(10,3,FALSE) = 0.0008101511794681433
- POISSON(21.7,7.54,TRUE) = 0.9999955033358848
- POISSON(21.7,7.54,FALSE) = 0.00000948031184308478