POISSON Function

Returns the probability from a Poisson distribution.

Category: Probability
Returned data type: DOUBLE

Syntax

POISSON(m, n)

Arguments

m

specifies any valid expression that evaluates to a numeric mean parameter.

Range m ≥ 0
Data type DOUBLE
See <sql-expression>
FedSQL Expressions

n

specifies any valid expression that evaluates to a random variable.

Range n ≥ 0
Data type INTEGER
See <sql-expression>
FedSQL Expressions

Details

The POISSON function returns the probability that an observation from a Poisson distribution, with mean m, is less than or equal to n. To compute the probability that an observation is equal to a given value, n, compute the difference of two probabilities from the Poisson distribution for n and n−1.

Example

The following statement illustrates the POISSON function:
Statements
Results
select poisson(1, 2);
0.9196986029
Last updated: February 23, 2017