Spread 8.0 Documentation
POISSON
Support Options
Formula Reference > Built-In Functions > POISSON

Glossary Item Box

POISSON


Name

Poisson distribution

Description

Returns the Poisson distribution.

Syntax

POISSON(nevents,mean,cumulative)

Remarks

The arguments are as follows:

Argument Description
nevents Number of events Provide an integer, or the value is truncated. The number must be greater than zero
mean Expected numeric value The number must be greater than zero
cumulative Set to TRUE to return the cumulative Poisson probability that the number of random events occurring is between zero and nevents inclusive. Set to FALSE to return the Poisson probability mass function that the number of events occurring is exactly nevents

The cumulative Poisson probability is calculated as follows::

The Poisson probability mass function is calculated as follows::where x is the number of events (nevents argument), mu is the mean (mean argument).

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

POISSON(A3,B4,TRUE)
POISSON(R1C2,3,FALSE)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.