Documentation/How Tos/Calc: CHIDIST function
From Apache OpenOffice Wiki
< Documentation | How Tos
Revision as of 23:11, 1 June 2013 by Javier Lopez (talk | contribs)
CALC FUNCTIONS
Measures of Central Tendency
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND
Ranking
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
CHIDIST
Calculates values for a χ2-distribution.
Syntax:
CHIDIST(x; k)
- k is the (positive integer) degrees of freedom for the χ2-distribution.
- x is a number >=0.
- CHIDIST returns the right tail probability for the χ2-distribution:
Issues:
- The draft international standard ODFF calls this function LEGACY.CHIDIST, and defines a new CHISQDIST function. * CHISQDIST is expected for OOo 3.1
- The draft international standard ODFF has no restriction for x, but defines that LEGACY.CHIDIST returns 1 for x ≤ 0.
Example:
CHIDIST(2; 3)
- returns approximately 0.5724.