# Documentation/Calc Functions/FINV

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

## Function name:

FINV

## Category:

Statistical Analysis

## Summary:

Calculates the inverse of the right-tailed probability distribution function for the F distribution. The F distribution is used for F tests in order to set the relation between two different data sets.

## Syntax:

FINV(**Number**; **degreesFreedom1**; **degreesFreedom2**)

## Returns:

Returns a real number which is the inverse of the right-tailed probability distribution function for the F distribution.

## Arguments:

**Number** is a real number in the range [0,1] or a reference to the cell containing that number which is the probability value for which the inverse F distribution is to be calculated.

**degreesFreedom1** is a real number or a reference to the cell containing that number which is the degrees of freedom in the numerator in the F distribution.

**degreesFreedom2** is a real number or a reference to the cell containing that number which is the degrees of freedom in the denominator in the F distribution.

- If
**Number**is greater than 1 or less than 0 or**degreeFreedom1**/**degreeFreedom2**is less than 1, then the function returns an error value. - If
**degreeFreedom1**or**degreeFreedom2**is a non-integer value then the function uses its floor value, i.e. truncates it to an integer.

## Additional details:

If FDIST(x;degreesfreedom1;degreesfreedom2) = p, then FINV(p;degreesfreedom1;degreesfreedom2) =x.

## Examples:

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

=FINV(0.4;5;10) | The function calculates the inverse of the right-tailed probabily distribution function for the F distribution. | 1.14118925345443 |

=FINV(0.75;4;7) | The function calculates the inverse of the right-tailed probabily distribution function for the F distribution. This can alternatively be considered as =FDIST(0.48100036666193;4;7) gives 0.75. | 0.48100036666193 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

FINV