Manuals/calci/poisson

POISSON(X, Mean, Cumulative)

where,

X - are represents number of events.

Mean - is the expected numeric values.

Cumulative - returned the logical value that determines the form of the probability distribution.

If TRUE - returnd the cumulative Poisson probability that the number of random events occuring will be between 0 and X.

If FALSE -returns the Poisson probability mass function that the number of events occuring will be exactly X.

Returns the Poisson distribution.

Formula :-

If Cumulative =FALSE

POISSON = (e^{-λ _λ× _{) / x!}}

If Cumulative = TRUE

POISSON = Σ(e^{-λ _λ×_{) /k!}}

If X orMean is nonnumeric, POISSON returns the #ERROR.

If X < 0 or Mean < 0 ,POISSON returns the #ERROR.

POISSON

Lets see an example in (Column1, Row1)

=POISSON(5,6,TRUE)

POISSON returns 0.44568.

Cosider an another example

=POISSON(3,4,false)

POISSON returns 0.195367.

Syntax

Remarks

Examples

Description

Navigation menu