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 |
||
| (6 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE:GAMMA function}} |
| + | {{Documentation/CalcFunc StatisticalTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_FTEST_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_GAMMAINV_function | ||
| + | }}__NOTOC__ | ||
== GAMMA == | == GAMMA == | ||
| Line 29: | Line 34: | ||
For x < 0.5 Eulers reflection formula is used. | 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. | + | 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 | If x is a positive integer, then | ||
: <math>\displaystyle \Gamma(x)=(x-1)\mathrm ! </math> | : <math>\displaystyle \Gamma(x)=(x-1)\mathrm ! </math> | ||
| − | But be aware, that | + | But be aware, that {{AOo}} has only a precision of 15 digits and results, which would consists of more than 15 significant digits, are rounded. |
=== See also === | === See also === | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]] |
| − | * [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]] |
* [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]] | * [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc: FACT function|FACT]] |
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]] | * [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]] | ||
| Line 47: | Line 52: | ||
* [[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/Statistical functions]] | |
| − | |||
| − | |||
Latest revision as of 13:56, 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
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 Apache OpenOffice has only a precision of 15 digits and results, which would consists of more than 15 significant digits, are rounded.
