Returns the inverse of the cumulative F distribution. The F distribution is used for F tests in order to set the relation between two differing data sets.
F.INV(Number; degreesFreedom1; degreesFreedom2)
Returns a non-negative real number which is the inverse of the cumulative distribution function for the F distribution.
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.
If F.DIST(x;degreesfreedom1;degreesfreedom2;TRUE()) = p, then F.INV(p;degreesfreedom1;degreesfreedom2) =x.
|=F.INV(0.5;5;10)||The function calculates the inverse of the cumulative F distribution.||0.931933160851048|
|=F.INV(0.75;4;7)||The function calculates the inverse of the cumulative F distribution. This can alternatively be considered as =F.DIST(1.71573803737036;4;7) gives 0.75.||1.71573803737036|
Related LibreOffice functions:
Equivalent Excel functions: