# CHISQ.INV

Calculates the inverse of the left-tailed chi-squared distribution.

### Sample Usage

`CHISQ.INV(0.42, 2)`

`CHISQ.INV(A2, B2)`

### Syntax

`CHISQ.INV(probability, degrees_freedom)`

• `probability` - The probability associated with the left-tailed chi-squared distribution.

• Must be greater than `0` and less than `1`.

• `degrees_freedom` - The number of degrees of freedom of the distribution.

### Notes

• `degrees_freedom` is truncated to an integer if a non-integer is provided.

• `degrees_freedom` must be at least `1`.

• All arguments must be numeric.

`CHIDIST`: Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.

`CHIINV`: Calculates the inverse of the right-tailed chi-squared distribution.

`CHISQ.INV.RT`: Calculates the inverse of the right-tailed chi-squared distribution.

`CHITEST`: Returns the probability associated with a Pearson’s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.

`F.INV`: Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.

`T.INV`: Calculates the negative inverse of the one-tailed TDIST function.

### Example

Suppose you want to find the cutoff for the chi-squared statistic associated with a left-tailed probability of `0.95`. With `4` degrees of freedom, you can consider any chi-squared statistic larger than `3.36` to be statistically significant.

A B C
1 Probability Degrees freedom Solution
2 0.95 4 9.487729037
3 0.95 4 =CHISQ.INV(0.95, 4)
4 0.95 4 =CHISQ.INV(A2, B2)