POISSON function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
POISSON
Calculates values for a Poisson distribution.
Syntax:
POISSON(x; λ; mode)
- The Poisson distribution is a discrete probability distribution giving the probability that x events occur in a certain time, where events occur independently, and where on average λ events are expected. x should be >=0 and λ should be >0. x should be integer.
- If mode is 0, POISSON calculates the probability density function of the Poisson distribution:
- If mode is 1, POISSON calculates the cumulative distribution function of the Poisson distribution:
Example:
POISSON(8; 9; 0)
- returns approximately 0.1317, the probability that exactly 8 events occur in a time period where you expect 9 events.
POISSON(8; 9; 1)
- returns approximately 0.4556, the probability that up to and including 8 events occur in a time period where you expect 9 events.
See Also
