Difference between revisions of "Documentation/How Tos/Calc: POISSON function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Syntax:: correction: lamda need not be integer) |
m |
||
| (6 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE:POISSON function}} |
| + | {{Documentation/CalcFunc StatisticalTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_PHI_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_PROB_function | ||
| + | }}__NOTOC__ | ||
== POISSON == | == POISSON == | ||
| Line 21: | Line 26: | ||
: returns approximately 0.4556, the probability that up to and including 8 events occur in a time period where you expect 9 events. | : returns approximately 0.4556, the probability that up to and including 8 events occur in a time period where you expect 9 events. | ||
| − | + | {{SeeAlso|EN| | |
| − | [[Documentation/How_Tos/Calc: Statistical functions| | + | * [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]] |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
| + | [[Category: Documentation/Reference/Calc/Statistical functions]] | ||
Latest revision as of 14:25, 2 February 2024
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
