Difference between revisions of "User:Regina"
(→Syntax) |
|||
Line 126: | Line 126: | ||
: <math>\Gamma(x) = \int_0^\infty t^{x-1} \mathrm e^{- t} \mathrm d t \,\!</math>. | : <math>\Gamma(x) = \int_0^\infty t^{x-1} \mathrm e^{- t} \mathrm d t \,\!</math>. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
=== Example === | === Example === | ||
Line 139: | Line 133: | ||
: <tt>'''GAMMA(−4)'''</tt> not defined | : <tt>'''GAMMA(−4)'''</tt> 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 and will overflow easily. | ||
+ | |||
+ | If x is a positive integer, then | ||
+ | : <math>\displaystyle \Gamma(x)=(x-1)\mathrm ! </math> | ||
+ | But be aware, that OpenOffice.org has only a precision of 15 digits, therefore the results for x > 21 are rounded. | ||
=== See also: === | === See also: === |
Revision as of 19:24, 30 September 2008
- native language
- German
- active in project
- de, qa. sc
- OOo user name
- regina
- special interest
- www.ooowiki.de
Sandbox
CHISQDIST
Calculates values for a χ2-distribution.
Syntax
CHISQDIST(x; k; Cumulative)
- x is a number.
- k is degrees of freedom for the χ2-distribution
- Constraint: k must be a positive integer
- Cumulative is a logical value.
- In the case Cumulative=TRUE() the cumulative distribution function is used, in the case Cumulative=FALSE() the probability density function. This parameter is optional. It is set to TRUE() if missing.
Semantic
CHISQDIST(x; k; FALSE()) returns the probability density function for the χ2-distribution:
and
CHISQDIST(x; k; TRUE()) returns the left tail probability for the χ2-distribution:
and
Semantic with forced pictures
CHISQDIST(x; k; FALSE()) returns the probability density function for the χ2-distribution:
and
CHISQDIST(x; k; TRUE()) returns the left tail probability for the χ2-distribution:
and
Example
CHSQDIST(2.7;3;FALSE())
- returns approximately 0.1699395239
CHSQDIST(2.7;3;TRUE())
- returns approximately 0.5597727056
.
See also:
CHISQINV, LEGACY.CHIDIST, LEGACY.CHIINV, CHITEST
Functions listed alphabetically, Functions listed by category
Issues:
This function is expected for OOo3.1
CHISQINV
Calculates the inverse of the CHISQDIST function.
Syntax
CHISQINV(p; k)
- k is the degrees of freedom for the χ2-distribution.
- Constraint: k must be a positive integer
- p is the given probability
- Constraint: 0 ≤ p < 1
Semantic
- CHISQINV(p; k) returns the value x, such that CHISQDIST(x; k;TRUE()) = p.
Example
CHISQINV(0.5724; 3)
- returns approximately 2.
See also:
Functions listed alphabetically, Functions listed by category
Issues:
- This function is expected for OOo3.1
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 and will overflow easily.
If x is a positive integer, then
But be aware, that OpenOffice.org has only a precision of 15 digits, therefore the results for x > 21 are rounded.
See also:
GAMMALN, GAMMADIST, GAMMAINV, FACT
Functions listed alphabetically, Functions listed by category
Issues:
This function is expected for OOo3.1.