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 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.
- 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:
ODF standard:
Related (or similar) Excel functions:
FINV