The F.INV.RT function calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
Sample Usage
F.INV.RT(0.42, 2, 3)
F.INV.RT(A2, B2, C2)
Syntax
F.INV.RT(probability, degrees_freedom1, degrees_freedom2)
-
probability
- The probability associated with the right-tailed F-distribution.-
Must be greater than
0
and less than1
.
-
-
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.
Notes
-
Both
degrees_freedom1
anddegrees_freedom2
are truncated to an integer in the calculation if a non-integer is provided as an argument. -
Both
degrees_freedom1
anddegrees_freedom2
must be at least1
. -
All arguments must be numeric.
-
F.INV.RT
is synonymous withFINV
.
See Also
CHIINV
: Calculates the inverse of the right-tailed chi-squared distribution.
F.DIST
: 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.
F.INV
: Calculates the inverse of the left-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.
TINV
: Calculates the inverse of the two-tailed TDIST function.
Example
Suppose you want to find the cutoff for the F statistic associated with a p-value of 0.05
. With 4
and 5
as the degrees of freedom, you can consider any F statistic larger than 5.19
to be statistically significant.
A | B | C | D | |
---|---|---|---|---|
1 | Probability | Degrees freedom numerator | Degrees freedom denominator | Solution |
2 | 0.05 | 4 | 5 | 5.192167773 |
3 | 0.05 | 4 | 5 | =F.INV.RT(0.05, 4, 5) |
4 | 0.05 | 4 | 5 | =F.INV.RT(A2, B2, C2) |