Returns the Poisson distribution for a given number of events and mean.
Składnia
POISSON.DIST(x, mean, cumulative)Argumenty
xwymagane
The number of events to evaluate.
meanwymagane
The expected number of occurrences.
cumulativewymagane
A logical value that determines the form of the probability distribution returned.
This function calculates the probability of a specific number of events occurring in a fixed interval of time or space. It is commonly used in quality control and forecasting to model the number of times an event occurs over a specific period.
=POISSON.DIST(2, 5, FALSE)→0.084224Calculates the probability of exactly 2 events occurring when the mean is 5.
Identify parameters
Determine the number of events (x) and the average rate (mean) for your dataset.
Choose distribution type
Set cumulative to TRUE for the cumulative Poisson probability, or FALSE for the probability mass function.
TRUE returns the probability that the number of random events occurring will be between zero and x inclusive; FALSE returns the probability that the number of events will be exactly x.