Difference between revisions of "Documentation/How Tos/Calc: GAMMA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(New page: __NOTOC__ == GAMMA == Returns the values of the Gamma function. === Syntax === <tt>'''GAMMA(x)'''</tt> :<tt>'''x'''</tt> is a number. :: Constraint: If x is an integer, then x must be ...) |
m |
||
| (9 intermediate revisions by 5 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 18: | Line 23: | ||
=== Example === | === Example === | ||
| − | + | {| | |
| − | + | |<tt>'''GAMMA(4) = 6.0'''</tt> exact | |
| − | + | <tt>'''GAMMA(34.56)''' ≈ 6.2336323276E+037 </tt> | |
| + | |||
| + | <tt>'''GAMMA(−4)'''</tt> not defined | ||
| + | || [[Image:GammaFunction.png|Graph of the Gamma function]] | ||
| + | |} | ||
=== Remarks === | === Remarks === | ||
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| | + | * [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]] |
| − | [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc: FACT function|FACT]] |
| − | [[Documentation/How_Tos/Calc: Mathematical functions| | + | * [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]] |
| − | [[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 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.
