Documentation/Calc Functions/FINV

    From The Document Foundation Wiki

    Function name:

    FINV

    Category:

    Statistical Analysis

    Summary:

    Calculates the inverse of a right-tail probability value for the F-distribution with given degrees of freedom.

    F-distributions (named in recognition of Sir Ronald Fisher) are a family of continuous probability distributions on the interval [0, +∞) that often arise in the statistical analysis of variance. The F-distribution has two characteristic parameters, known as the degrees of freedom for the numerator and the degrees of freedom for the denominator and these determine the shape of the distribution.

    FINV is the inverse of FDIST, so that for valid arguments [math]\displaystyle{ \text{FINV}(\text{FDIST}(x;\:ν1;\:ν2);\:ν1;\:ν2)~=~x }[/math].

    Syntax:

    FINV(Number; Degrees freedom 1; Degrees freedom 2)

    Returns:

    Returns a non-negative real number, which is the inverse of the specified right-tail probability value for the given F-distribution.

    Arguments:

    Number is a real number in the range (0, 1], or a reference to a cell containing that number, which is the right-tail probability for which the inverse is required.

    Degrees freedom 1 is a positive integer, or a reference to a cell containing that number, which is the degrees of freedom for the numerator of the F-distribution.

    Degrees freedom 2 is a positive integer, or a reference to a cell containing that number, which is the degrees of freedom for the denominator of the F-distribution.

    • If any of Number, Degrees freedom 1, or Degrees freedom 2 is non-numeric, then FINV reports a #VALUE! error.
    • If Number is less than or equal to 0.0, or greater than 1.0, then FINV reports an invalid argument error (Err:502).
    • If either Degrees freedom 1 or Degrees freedom 2 is less than 1.0, then FINV reports an invalid argument error (Err:502).
    • If either Degrees freedom 1 or Degrees freedom 2 is greater than or equal to [math]\displaystyle{ 1.0 \times 10^{10} }[/math], then FINV reports an invalid argument error (Err:502).
    • If either Degrees freedom 1 or Degrees freedom 2 is a non-integer value, then FINV truncates it to an integer value.
    • If the function’s iterative algorithm does not converge for the given arguments, then FINV reports a calculation does not converge error (Err:523).

    Additional details:

    • Calc's FINV and F.INV.RT functions perform identical calculations. The requirements for FINV are specified in ODF 1.2; F.INV.RT is provided for interoperability with Microsoft Excel.
    • FINV utilizes an iterative algorithm to determine the inverse of the specified right-tail probability.
    • The following figure shows inverse right-tail probability plots for five sample F-distributions.
    F distribution inverse RT probability plots.png
    • For more information about F-distributions, visit Wikipedia's F-distribution page.

    Examples:

    Formula Description Returns
    =FINV(A1; A2; A3) where cells A1:A3 contain the values 0.614339643745812, 8 and 12 respectively. Here the function calculates the inverse of a right-tail probability value for the specified F-distribution. Note that the formula =FINV(0.614339643745812; 8.9; 12.95) returns the same result because the non-integer degrees of freedom values are truncated. 0.8
    =FINV(0.0354938271604938; 6; 6) Here the function calculates the inverse of a right-tail probability value for the specified F-distribution. Note that the formula =F.INV.RT(0.0354938271604938; 6; 6) returns the same result. 5

    Related LibreOffice functions:

    F.DIST

    F.DIST.RT

    F.INV

    F.INV.RT

    F.TEST

    FDIST

    FTEST

    ODF standard:

    Section 6.18.25, part 2

    Related (or similar) Excel functions:

    FINV