POISSON
Name
Poisson distribution
Description
Returns the Poisson distribution.
Syntax
POISSON(nevents,mean,cumulative)
Remarks
The arguments are as follows:
Argument | Description |
---|---|
nevents | Number of events Provide an integer, or the value is truncated. The number must be greater than zero |
mean | Expected numeric value The number must be greater than zero |
cumulative | Set to TRUE to return the cumulative Poisson probability that the number of random events occurring is between zero and nevents inclusive. Set to FALSE to return the Poisson probability mass function that the number of events occurring is exactly nevents |
The cumulative Poisson probability is calculated as follows::
The Poisson probability mass function is calculated as follows::where x is the number of events (nevents argument), mu is the mean (mean argument).
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
POISSON(A3,B4,TRUE)
POISSON(R1C2,3,FALSE)