POISSON function - The function returns the Poisson distribution in Excel

In predicting the number of events that occur within a specific time, one cannot help but use the POISSON function. The following article details how to use the POISSON function, the function returns the Poisson distribution.

Description: The function returns the Poisson distribution, which is the basis for determining the number of events occurring over a defined period, for example, with the vehicle density on weekends, the number of vehicles passing through the toll booth in 1 minute. From the anticipation, there will be specific support measures.

Syntax: POISSON (x, mean, cumulative) .

Inside:

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

- mean: The value to be estimated (value in the form of numbers), is a required parameter.

- cumulative: A logical value that determines the format of the return value. The following values ​​are available:

+ cumulative = TRUE => function returns the cumulative Poisson probability that 0

+ cumulative = FALSE: function returns the cumulative Poisson probability that the number of events = x.

Attention:

- Poission function is calculated by the formula:

+ cumulative = TRUE:

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

+ cumulative = FALSE:

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

- If x is a decimal, the function takes an integer value of x.

- x and the value must be numeric otherwise the function returns the #VALUE error.

- If x

- If mean the function returns the value #NUM !.

For example:

- Calculate Poission when cumulative = True :

In the cell to calculate enter the formula: = POISSON (D13, D14, D15) .

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

Pressing Enter results as:

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

- Calculate Poission when cumulative = False :

In the cell to calculate enter the formula: = POISSON (D13, D14, D16) .

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

Pressing Enter results as:

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

Thus the Poission function value at the cumulative value is different. Hopefully the Poission function will help you in predicting events that occur in a specified time period.

Good luck!