Returns the value of the Poisson distribution function or the Poisson cumulative distribution function for a specified number and mean.
Sample Usage
POISSON.DIST(2.4,1,TRUE)
POISSON.DIST(A2,A3,FALSE)
Syntax
POISSON.DIST(number, mean, [cumulative])
- number - The input to the distribution function.
- mean - The mean value of the Poisson distribution.
- cumulative - [OPTIONAL] A logical value that determines the form of the probability distribution to be returned.
Examples
POISSON.DIST(2.4,1,TRUE) returns a value of 0.9196, the cumulative poisson probability with the arguments specified.
Notes
- Set cumulative to TRUE to use the cumulative distribution function, and set it to FALSE to use the probability mass function.