The POISSON function returns the probability that a specific number of events will occur using the Poisson distribution.
POISSON(events, average, form-type)
events: A number value representing the number of events (arrivals) for which you want to calculate the probability.
average: A number value representing the known average (arithmetic mean) rate at which events occur.
form-type: A modal value that indicates which form of the exponential function to provide.
cumulative form (TRUE or 1): Return the value of the cumulative distribution form (that the specified number or fewer successes or events will occur).
probability mass form (FALSE or 0): Return the value of the probability mass form (that there are exactly the specified number of successes or events).
Example |
|---|
For a mean of 10 and an arrival rate of 8: =POISSON(8, 10, FALSE) returns approximately 0.11259903214902. |