POISSON.DIST function - The function returns the Poisson distribution in Excel

The following article introduces you to the POISSON.DIST function - one of the functions in the statistical function group is very popular in Excel.

POISSON.DIST function - The function returns the Poisson distribution in Excel Picture 1

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:

POISSON.DIST function - The function returns the Poisson distribution in Excel Picture 2

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

POISSON.DIST function - The function returns the Poisson distribution in Excel Picture 3

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

POISSON.DIST function - The function returns the Poisson distribution in Excel Picture 4

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

POISSON.DIST function - The function returns the Poisson distribution in Excel Picture 5

- Press Enter -> return value is:

POISSON.DIST function - The function returns the Poisson distribution in Excel Picture 6

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

Good luck!