Difference between revisions of "Manuals/calci/poisson"
Jump to navigation
Jump to search
Line 18: | Line 18: | ||
==Examples== | ==Examples== | ||
− | #POISSON(6,2,TRUE)=0.995466194 | + | #=POISSON(6,2,TRUE) = 0.995466194 |
− | #POISSON(6,2,FALSE)=0.012029803 | + | #=POISSON(6,2,FALSE) = 0.012029803 |
− | #POISSON(10.2,7,TRUE)=0.901479206 | + | #=POISSON(10.2,7,TRUE) = 0.901479206 |
− | #POISSON(10.2,7,FALSE)=0.070983269 | + | #=POISSON(10.2,7,FALSE) = 0.070983269 |
− | #POISSON(6,0,TRUE)=1 | + | #=POISSON(6,0,TRUE) = 1 |
==See Also== | ==See Also== |
Revision as of 03:31, 7 January 2014
POISSON(x,m,cu)
- 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 0 and x(included).
- If it is FALSE,this function will give the Poisson probability mass function with the number of events occurring will be exactly x.
- The probability mass function is: , is the shape parameter and >0. 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(6,2,TRUE) = 0.995466194
- =POISSON(6,2,FALSE) = 0.012029803
- =POISSON(10.2,7,TRUE) = 0.901479206
- =POISSON(10.2,7,FALSE) = 0.070983269
- =POISSON(6,0,TRUE) = 1