Difference between revisions of "Documentation/How Tos/Calc: CHIDIST function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (talk | contribs) |
Javier Lopez (talk | contribs) |
||
Line 3: | Line 3: | ||
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | ||
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]] | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]] | ||
− | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc: | + | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CHIINV_function |
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_BINOMDIST_function | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_BINOMDIST_function | ||
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions |
Revision as of 23:11, 1 June 2013
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.