Excel Function : POISSON.DIST

Download now!

Excel Function : POISSON.DIST




Returns the Poisson distribution

Microsoft Excel Reference Page


Syntax and Description of the POISSON.DIST Excel Function

The syntax for the POISSON.DIST function in Microsoft Excel is: POISSON.DIST( x, mean, cumulative ) Where: x – The number of events. mean – The expected number of events. cumulative – A logical value that determines the form of the function. If cumulative is TRUE, POISSON.DIST returns the cumulative Poisson probability that the number of random events observed in a given interval will be between 0 and x inclusive; if FALSE, it returns the Poisson probability mass function that the number of events observed in a given interval is exactly x. Example: Suppose we have a Poisson distribution with a mean

About POISSON.DIST Excel Function

The POISSON.DIST function returns the probability that there are a given number of events, x, in a given time period, t, when the average number of events in that period is known, λ (lambda).