Difference between revisions of "User:Regina"
(→Syntax) |
(→Syntax) |
||
Line 84: | Line 84: | ||
: <tt>'''k'''</tt> is the degrees of freedom for the χ<sup>2</sup>-distribution. | : <tt>'''k'''</tt> is the degrees of freedom for the χ<sup>2</sup>-distribution. | ||
− | Constraint: k must be a positive integer | + | :: Constraint: k must be a positive integer |
: <tt>'''p'''</tt> is the given probability | : <tt>'''p'''</tt> is the given probability | ||
− | Constraint: 0 ≤ p < 1 | + | :: Constraint: 0 ≤ p < 1 |
=== Semantic === | === Semantic === |
Revision as of 19:15, 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
- .
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.