User:Regina
- 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 the (positive integer) degrees of freedom for the χ2-distribution.
- 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 (positive integer) degrees of freedom for the χ2-distribution.
- p is the given probability, a number with
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
- .
For x < 0.5 Eulers reflection formula is use.
The Gamma function has poles for negative integers and for zero. Near to poles the values might be less accurate.
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.
Example
- GAMMA(4) = 6.0 exact
- GAMMA(34.56) ≈ 6.2336323276E+037
- GAMMA(−4) not defined
See also:
GAMMALN, GAMMADIST, GAMMAINV, FACT
Functions listed alphabetically, Functions listed by category
Issues:
This function is expected for OOo3.1.