POISSON.DIST function
POISSON.DIST(x,
mean, isCumulative) POISSON.DIST(x;
mean; isCumulative)
x
Number or { Number }
The number of events.
mean
Number or { Number }
The expected number.
isCumulative
Logical or { Logical }
FALSE to calculate the probability mass function and TRUE to calculate the cumulative distribution function.
Returns
Number or { Number }
A value for a Poisson distribution.
Returns a value for a Poisson distribution.
Examples
POISSON.DIST(8, 9,
FALSE)POISSON.DIST(8; 9;
FALSE)
Returns roughly 0.1318, the probability that exactly eight events occur in a time period where you expect nine events.
POISSON.DIST(8, 9,
TRUE)POISSON.DIST(8; 9;
TRUE)
Returns roughly 0.4557, the probability that up to and including eight events occur in a time period where you expect nine events.
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.