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.