POISSON

Returns the Poisson distribution for a specified value at a given mean. The Poisson distribution predicts the number of events that occur in a specified time.

Syntax

POISSON(x; λ; mode)

x: The value at which you want to calculate the Poisson distribution. Eg., 5

λ: The mean of the Poisson distribution. Eg., 2

mode: Determines which function to return.

0 or FALSE - POISSON calculates the probability density function of the Poisson distribution

1 or TRUE - POISSON calculates the cumulative distribution function of the Poisson distribution

Examples

Formula	Result
=POISSON(A2;B2;C2)	0.036089409
=POISSON(A3;B3;C3)	0.901479206
=POISSON(A4;B4;C4)	0.021604031

Get a hands-on experience of the function in the embedded range below.

Possible Errors

Errors	Meaning
#N/A!	The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.
#NAME!	The function name is incorrect or invalid. The given defined name (if any) is invalid. There is a typo in the defined name used in the function. Double quotes are missing for text values in the function. Colon missing in a cell range reference.
#VALUE!	The given argument's data type is incorrect or invalid. For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.
#REF!	The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved or pasted over.
#NUM!	The value of x is less than 0. The value of λ is less than 0.

Similar Functions

BINOMDIST
CRITBINOM
EXPONDIST
HYPGEOMDIST
LOGINV
LOGNORMDIST
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PROB
WEIBULL

POISSON function - Zoho Sheet - Help Guide

POISSON