Difference between revisions of "Documentation/How Tos/Calc: CHISQDIST function"
(→Issues:) |
(→Example) |
||
Line 41: | Line 41: | ||
|- | |- | ||
|<tt>'''CHISQDIST(2.3;15;FALSE())'''</tt> | |<tt>'''CHISQDIST(2.3;15;FALSE())'''</tt> | ||
− | : returns approximately 0,000209862 | + | :returns approximately 0,000209862 |
<tt>'''CHISQDIST(2.3;2;FALSE())'''</tt> | <tt>'''CHISQDIST(2.3;2;FALSE())'''</tt> | ||
Line 52: | Line 52: | ||
|- | |- | ||
|<tt>'''CHISQDIST(1.5;2;TRUE())'''</tt> | |<tt>'''CHISQDIST(1.5;2;TRUE())'''</tt> | ||
− | : returns approximately 0,5276334 | + | :returns approximately 0,5276334 |
other valid call: <tt>'''CHISQDIST(1.5;2)'''</tt> | other valid call: <tt>'''CHISQDIST(1.5;2)'''</tt> | ||
|[[Image:ChiDistributionCumulativeLeftTail.png|Chi-distribution cumulative functions]] | |[[Image:ChiDistributionCumulativeLeftTail.png|Chi-distribution cumulative functions]] | ||
Line 60: | Line 60: | ||
|- | |- | ||
|<tt>'''CHISQDIST(18;15;TRUE())'''</tt> | |<tt>'''CHISQDIST(18;15;TRUE())'''</tt> | ||
− | : returns approximately 0,73733444 | + | :returns approximately 0,73733444 |
|[[Image:ChiDistributionLeftTailArea.png|Area under density function]] | |[[Image:ChiDistributionLeftTailArea.png|Area under density function]] | ||
Revision as of 21:21, 22 December 2008
This function is not yet implemented but expected for OpenOffice.org version 3.1.
CHISQDIST
Calculates values for a χ2-distribution.
Syntax
CHISQDIST(x; k; Cumulative)
- x is the number, at which you will evaluate the χ2-distribution.
- k sets the 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 values of the probability density function for the χ2-distribution:
CHISQDIST(x;k;TRUE()) returns the left tail probability for the χ2-distribution:
Example
CHISQDIST(2.3;15;FALSE())
CHISQDIST(2.3;2;FALSE())
|
CHISQDIST(1.5;2;TRUE())
other valid call: CHISQDIST(1.5;2) |
CHISQDIST(18;15;TRUE())
|
Remarks
If you need CHISQDIST(x;k;TRUE()) with a non integer parameter k, then use GAMMADIST(x;k/2;2) instead.
For to get the right tail for large values x, do not calculate 1 − CHISQDIST. It is less accurate in those cases than using CHIDIST. CHISQDIST(x;k;TRUE()) + CHIDIST(x;k) = 1.
In the density case the internal calculation uses logarithmic- and exponential function, if x >1425 or x · k > 1391000. The results are less accurate in those cases.
See also
CHISQINV, LEGACY.CHIDIST, LEGACY.CHIINV, CHITEST
Functions listed alphabetically, Functions listed by category
Issues
This function is not available in version 3.0 and earlier.