ChiDist() returns the one-tailed probability of the chi2 distribution. The chi2 distribution is associated with a chi2 test.
Syntax:
ChiDist(value, degrees_freedom)
Return data type: number
Arguments:
| Argument | Description |
|---|---|
| value | The value at which you want to evaluate the distribution. The value must not be negative. |
| degrees_freedom | A positive integer stating the number of degrees of freedom. |
This function is related
to the ChiInv function in the following way:
If prob = ChiDist(value,df),
then ChiInv(prob, df) = value
Limitations:
All arguments must be numeric, else NULL will be returned.
Examples and results:
| Example | Result |
|---|---|
| CHIDIST( 8, 15) | Returns 0.9238 |
