Excel functions / Statistics
F.DIST.RT function
The right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
Syntax
=F.DIST.RT(x, deg_freedom1, deg_freedom2)
Arguments
x: The F statistic, 0 or more.deg_freedom1: The degrees of freedom of the numerator.deg_freedom2: The degrees of freedom of the denominator.
When to use it
F.DIST.RT gives the chance of an F ratio greater than x: the p-value of an F statistic, as in an analysis of variance.
Examples
p-value of 15.2069 with 6 and 4 degrees of freedom
A B C D E 1 x df1 df2 2 15.2069 6 4 0.010 In E2:
=F.DIST.RT(A2, B2, C2)→ 0.010
Common mistakes
- Degrees of freedom. The numerator's degrees of freedom come first.
F.DIST.RT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: F.DIST.RT
- Danish: F.FORDELING.RT
- Dutch: F.VERD.RECHTS
- Finnish: F.JAKAUMA.OH
- French: LOI.F.DROITE
- German: F.VERT.RE
- Hungarian: F.ELOSZLÁS.JOBB
- Italian: DISTRIB.F.DS
- Norwegian: F.FORDELING.H
- Polish: ROZKŁ.F.PS
- Portuguese (Brazil): DIST.F.CD
- Portuguese (Portugal): DIST.F.DIR
- Russian: F.РАСП.ПХ
- Spanish: DISTR.F.CD
- Swedish: F.FÖRD.RT
- Turkish: F.DAĞ.SAĞK
Also written as FDIST.
Try F.DIST.RT in the playground
Related functions
- F.DIST: The F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
- F.INV.RT: The F value with a given share of the distribution above it: the critical value of an F-test.
- F.TEST: The F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.