POISSON Function Explained
The POISSON
function in Microsoft Excel calculates the probability of a given number of events occurring in a fixed interval of time or space, given a known average rate of occurrence. It takes two arguments: x
(the number of events) and mean
(the expected numeric value). It returns the probability of x
events occurring in the given interval.
POISSON Function Syntax
POISSON(x, mean, cumulative)
x
: The value at which to evaluate the function.mean
: The expected numeric value, which is the mean of the Poisson distribution.cumulative
: A logical value that determines the form of the function. If cumulative is TRUE, POISSON returns the cumulative Poisson probability that the number of random events occurring will be between zero and x; if FALSE, it returns the Poisson probability mass function that the exact number of events occurring is x.