Difference between revisions of "Documentation/How Tos/Calc: GAMMA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
Line 50: | Line 50: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Statistical functions]] |
Revision as of 12:11, 17 May 2010
GAMMA
Returns the values of the Gamma function.
Syntax
GAMMA(x)
- x is a number.
- Constraint: If x is an integer, then x must be positive.
Semantic
GAMMA(x) calculates
- .
Example
GAMMA(4) = 6.0 exact
GAMMA(34.56) ≈ 6.2336323276E+037 GAMMA(−4) not defined |
Remarks
For x < 0.5 Eulers reflection formula is used.
The Gamma function has poles for negative integers and for zero. Near the poles the values are less accurate.
If x is a positive integer, then
But be aware, that OpenOffice.org has only a precision of 15 digits and results, which would consists of more than 15 significant digits, are rounded.
Issues
This function is expected for OOo3.1. Issue 94555