Documentation/Calc Functions/FINV

From The Document Foundation Wiki
Jump to: navigation, search

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:

F.DIST.RT

F.DIST

F.TEST

FDIST

F.INV

F.INV.RT

FTEST

ODF standard:

None

Equivalent Excel functions:

FINV