# Documentation/Calc Functions/CHISQINV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

CHISQINV

## Category:

Statistical Analysis

## Summary:

Returns the inverse of the cumulative distribution function for the one-tailed chi-square distribution.

## Syntax:

CHISQINV(**Probability**; **DegreesFreedom**)

## Returns:

Returns a non-negative real number which is the inverse cumulative distribution function for the one-tailed chi-square distribution. If p = CHISQDIST(x;n), then CHISQINV(p,n) = x.

## Arguments:

**Probability** is a real number from 0 to 1 or a reference to the cell containing that number which is the probability value for which the inverse of the chi-square distribution is to be calculated.

**DegreesFreedom** is a positive integer or a reference to a cell containing that number which is the degrees of freedom for the chi-square function.

- If
**Probability**is greater than 1 or less than 0, then the function returns an error value. - If
**DegreesFreedom**is less than 1, the function returns an error value. - If
**DegreesFreedom**is a non-integer numeric value, then the function truncates it to an integer.

## Additional details:

For more details on the inverse chi-square distribution, visit **Wikipedia**

## Examples:

Formula | Description | Returns |
---|---|---|

=CHISQINV(0.75;5) | Inverse of the one-tailed probability of the chi-square distribution. Here we can check that =CHISQINV(CHISQDIST(0.020975769403022;5);5) returns 0.020975769403022. | 0.020975769403022 |

=CHISQINV(1.2;5) | Number greater than 1 so the function returns an error value |
Err:502 |

=CHISQINV(0.2;0.9) | DegreesFreedom less than 1 so the function returns an error value |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

None