Navigation:  Formula Reference > Spreadsheet Formula Functions >

POISSON.DIST

Previous pageReturn to chapter overviewNext page

 

This function returns the Poisson distribution.

Syntax

POISSON.DIST(nevents,mean,cumulative)

Remarks

This function has these arguments:

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.

Remarks

The cumulative Poisson probability is calculated as follows:

Func-POISSON-True

The Poisson probability mass function is calculated as follows:

Func-POISSON-False

where x is the number of events (nevents argument), mu is the mean (mean argument).

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

POISSON.DIST(A3,B4,TRUE)

POISSON.DIST(R1C2,3,FALSE)

POISSON.DIST(7,4,TRUE) gives the result 0.9488663842071525

POISSON.DIST(7,4,FALSE) gives the result 0.059540362609726345