Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
F.INV(0.42, 2, 3)
F.INV(A2, B2, C2)
F.INV(probability, degrees_freedom1, degrees_freedom2)
probability- The probability associated with the left-tailed F-distribution.
Must be greater than
0and less than
degrees_freedom1- The number of degrees of freedom of the numerator of the test statistic.
degrees_freedom2- The number of degrees of freedom of the denominator of the test statistic.
degrees_freedom2are truncated to an integer in the calculation if a non-integer is provided as an argument.
degrees_freedom2must be at least
All arguments must be numeric.
CHIINV: Calculates the inverse of the right-tailed chi-squared distribution.
FDIST: Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution.
FINV: Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
FTEST: Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.
T.INV: Calculates the negative inverse of the one-tailed TDIST function.
Suppose you want to find the cutoff for the F statistic associated with a left-tailed cumulative probability of
|1||Probability||Degrees freedom numerator||Degrees freedom denominator||Solution|
|3||0.95||4||5||=F.INV(0.95, 4, 5)|
|4||0.95||4||5||=F.INV(A2, B2, C2)|