POISSON(x, mean, cumulative)

Returns the probability of getting less than or equal to a particular value in a poisson distribution.

xThe number of events.
meanThe expected numeric value.
cumulativeThe type of function to use
True = cumulative probability function
False = probability mass function


* POISSON.DIST was added in Excel 2010 to replace this function.
* The Poisson distribution is a discrete distribution.
* A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
* If "x" is not an integer, it is truncated.
* If "x" is not numeric, then #VALUE! is returned.
* If "mean" is not numeric, then #VALUE! is returned.
* If "mean" = 0, then #NUM! is returned.
* If "x" < 0, then #NUM! is returned.
* If "x" = 0, then
* In Excel 2010 the accuracy of this function was improved.
* For the Microsoft documentation refer to support.office.com

1=POISSON(2,5,FALSE) = 0.084
2=POISSON(2,5,TRUE) = 0.125
3=POISSON(2,2,1) = 0.677
4=POISSON(-2,2,1) = #NUM!

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top