Documentation/How Tos/Calc: POISSON function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 18:01, 19 May 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


POISSON

Calculates values for a Poisson distribution.

Syntax:

POISSON(x; λ; mode)

The Poisson distribution is a discrete probability distribution giving the probability that a x events occur in a certain time, where events occur independently, and where on average λ events are expected.
If mode is 0, POISSON calculates the probability density function of the Poisson distribution:
Calc poisson0 equation.png
If mode is 1, POISSON calculates the cumulative distribution function of the Poisson distribution:
Calc poisson1 equation.png

Example:

POISSON(8; 9; 0)

returns approximately 0.1317, the probablity that exactly 8 events occur in a time period where you expect 9 events.

POISSON(8; 9; 1)

returns approximately 0.4556, the probablity that up to and including 8 events occur in a time period where you expect 9 events.

See also:

Statistical functions

Personal tools