Difference between revisions of "Documentation/How Tos/Calc: CHISQINV function"

Latest revision as of 13:46, 2 February 2024

FUNCTIONS

Spreadsheet Lookup functions

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND

Ranking

Calculates the inverse of the CHISQDIST function.

CHISQINV(p; k)

k is the degrees of freedom for the χ²-distribution.

Constraint: k must be a positive integer

p is the given probability

Constraint: 0 ≤ p < 1

CHISQINV(p; k) returns the value x, such that CHISQDIST(x; k;TRUE()) = p.

CHISQINV(0.5; 9)

returns approximately 8.342832692.

If you need CHISQINV(p;k) for a non-integer parameter k, then use GAMMAINV(p;k/2;2) instead.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:CHISQINV function}}
+{{Documentation/CalcFunc StatisticalTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_CHIINV_function
+|NextPage=Documentation/How_Tos/Calc:_CHITEST_function
+}}__NOTOC__
 == CHISQINV ==
@@ Line 20: / Line 25: @@
 === Example ===
 <tt>'''CHISQINV(0.5; 9)'''</tt>
-: returns approximately 8.342832692
+: returns approximately 8.342832692.
-.
 === Remarks ===
-If you need <tt>CHISQINV(p;k)</tt> for a non interger parameter k, then use <tt>GAMMAINV(p;k/2;2)</tt> instead.
+If you need <tt>CHISQINV(p;k)</tt> for a non-integer parameter k, then use <tt>GAMMAINV(p;k/2;2)</tt> instead.
-=== Issues ===
-* This function is expected for OOo3.1 {{Bug|94555}}
+{{SeeAlso|EN|
-{{Documentation/SeeAlso|
 * [[Documentation/How_Tos/Calc: CHISQDIST function|CHISQDIST]]
 * [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]]