POISSON. DIST Function in Excel

This guide provides a practical overview of POISSON. DIST Function, including its main features, benefits, limitations, and important considerations.

Description: The function returns the Poisson distribution, the application function to predict the number of events in a specific time. Support functions from Excel 2013 onwards.

Syntax: POISSON. DIST (x, mean, cumulative)

Inside:

- x: Number of events, is a required parameter .

- mean: The estimated numerical value, is a required parameter.

- cumulative: A logical value that determines the form of the function, which is a required parameter, including:

+ cumulative = True -> returns the cumulative distribution function.

+ cumulative = False -> returns the probability block function.

Attention:

- If x is not an integer -> it is truncated to an integer.

- If x or mean are not numeric -> the function returns the #VALUE! Error value

- If x <0 or mean <0 -> the function returns the #NUM! Error value

- The function POISSON. DIST with cumulative False is calculated based on the formula:

[{rm {POISSON}} = frac {{{e ^ {- lambda}} {lambda ^ x}}} {{x!}}]

- The function POISSON. DIST with cumulative True is calculated based on the formula:

[{rm {CUMPOISSON}} = sumlimits_ {k = 0} ^ x {frac {{{e ^ {- lambda}} {lambda ^ x}}} {{k!}}}]]

For example:

Calculate the probability of Poisson. dist with the data described in the following data table:

- Calculate cumulative probability POISSON . In a cell to calculate, enter the formula : = POISSON. DIST (D6, D7, D8)

- Press Enter -> the cumulative probability of POISSON is:

- Calculate probability function block POISSON . In a cell to calculate, enter the formula: = POISSON. DIST (D6, D7, D9)

- Press Enter -> return value is:

Above are instructions and some specific examples when using the POISSON. DIST function in Excel.

Good luck!