Difference between revisions of "Documentation/How Tos/Calc: POISSON function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (→‎Syntax:)
m
 
(10 intermediate revisions by 5 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 6: Line 11:
 
=== Syntax: ===
 
=== Syntax: ===
 
<tt>'''POISSON(x; &lambda;; mode)'''</tt>
 
<tt>'''POISSON(x; &lambda;; mode)'''</tt>
−
: The Poisson distribution is a discrete probability distribution giving the probability that <tt>'''x'''</tt> events occur in a certain time, where events occur independently, and where on average <tt>'''&lambda;'''</tt> events are expected.
+
: The Poisson distribution is a discrete probability distribution giving the probability that <tt>'''x'''</tt> events occur in a certain time, where events occur independently, and where on average <tt>'''&lambda;'''</tt> events are expected. <tt>'''x'''</tt> should be >=0 and <tt>'''&lambda;'''</tt> should be >0. <tt>'''x'''</tt> should be integer.
  
 
: If mode is <tt>'''0'''</tt>, <tt>'''POISSON'''</tt> calculates the probability density function of the Poisson distribution:
 
: If mode is <tt>'''0'''</tt>, <tt>'''POISSON'''</tt> calculates the probability density function of the Poisson distribution:
Line 16: Line 21:
 
=== Example: ===
 
=== Example: ===
 
<tt>'''POISSON(8; 9; 0)'''</tt>
 
<tt>'''POISSON(8; 9; 0)'''</tt>
−
: returns approximately 0.1317, the probablity that exactly 8 events occur in a time period where you expect 9 events.
+
: returns approximately 0.1317, the probability that exactly 8 events occur in a time period where you expect 9 events.
  
 
<tt>'''POISSON(8; 9; 1)'''</tt>
 
<tt>'''POISSON(8; 9; 1)'''</tt>
−
: returns approximately 0.4556, the probablity 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.
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
 +
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[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



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:
Calc poisson0 equation.png
If mode is 1, POISSON calculates the cumulative distribution function of the Poisson distribution:
Calc poisson1 equation.png

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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_POISSON_function&oldid=260064"
Views
Personal tools
Navigation
Tools