# F.INV

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

### Sample Usage

`F.INV(0.42, 2, 3)`

`F.INV(A2, B2, C2)`

### Syntax

`F.INV(probability, degrees_freedom1, degrees_freedom2)`

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

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

• `degrees_freedom1` - The number of degrees of freedom of the numerator of the test statistic.

• `degrees_freedom2` - The number of degrees of freedom of the denominator of the test statistic.

### Notes

• Both `degrees_freedom1` and `degrees_freedom2` are truncated to an integer in the calculation if a non-integer is provided as an argument.

• Both `degrees_freedom1` and `degrees_freedom2` must be at least `1`.

• All arguments must be numeric.

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

`FDIST`: Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.

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

`FTEST`: Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.

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

### Example

Suppose you want to find the cutoff for the F statistic associated with a left-tailed cumulative probability of `0.95`.

A B C D
1 Probability Degrees freedom numerator Degrees freedom denominator Solution
2 0.95 4 5 5.192167773
3 0.95 4 5 =F.INV(0.95, 4, 5)
4 0.95 4 5 =F.INV(A2, B2, C2)