Documentation/Calc Functions/POISSON

Function name:
POISSON

Category:
Statistical Analysis

Summary:
Calculates either a probability mass function or a cumulative distribution function of the Poisson distribution for a given value.

Syntax:
POISSON(Number; Mean; C)

Returns:
Returns a real number which is either a probability mass function or a cumulative distribution function of the Poisson distribution for Number with mean value as Mean.

Arguments:
Number is a real number or a reference to the cell containing that number which represents the value based on which the Poisson distribution is calculated.

Mean is a real number or a reference to the cell containing that number which represents the middle value of the Poisson distribution.

C can be 0 or False to calculate the probability mass function. It can be any other value or True to calculate the cumulative distribution function.


 * If Number is a non-integer value then the function uses its floor value, i.e. it is truncated to an integer. However, if the Number is less than 0 then the function returns an error value.
 * If Mean is less than 0 then the function returns an error value.

Additional details:

 * The formula for POISSON is:

If C is FALSE, POISSON returns the probability mass function value:

If C is TRUE, POISSON returns the cumulative distribution function value:

where x is Number
 * For more details on Poisson distribution, visit Wikipedia

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/POISSON.DIST POISSON.DIST]

ODF standard:
Section 6.18.62, part 2

Equivalent Excel functions:
POISSON