CHIINV
Syntax:
CHIINV ( probability , degrees-freedom )
Description: Computes the inverse of the one-tailed probability of the chi-squared distribution. Given a value for probability, CHIINV
seeks for a value x such that CHIDIST(
x,
degrees-freedom)
= probability. Thus, precision of CHIINV
depends on precision of CHIDIST
. CHIINV
uses an iterative search technique.
Arguments:
Name |
Type |
Description |
---|---|---|
probability |
number |
A probability associated with the chi-squared distribution. |
degrees-freedom |
number |
The number of degrees of freedom, truncated to an integer. |
Return Type and Value: number – The inverse of the one-tailed probability of the chi-squared distribution.
However, if
probability < 0 or probability > 1,
#NUM!
is returned.degrees-freedom < 1 or degrees-freedom ≥ 1010,
#NUM!
is returned.The search has not converged after some implementation-defined number of iterations,
#N/A
is returned