Documentation/How Tos/Calc: CHIINV function
From Apache OpenOffice Wiki
< Documentation | How Tos
Revision as of 23:12, 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 | }} > |
CHIINV
Calculates the inverse of the CHIDIST function.
Syntax:
CHIINV(p; k)
- k is the (positive integer) degrees of freedom for the χ2-distribution.
- CHIINV(p; k) returns the value x, such that CHIDIST(x; k) is p.
Example:
CHIINV(0.5724; 3)
- returns approximately 2.
Issues:
- The draft international standard ODFF calls this function LEGACY.CHIINV, and defines a new CHISQINV function.