Excel functions / Statistics
F.DIST function
The F-distribution: the chance of a ratio of two variances of x or less, or the height of the curve at x.
Syntax
=F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
Arguments
x: The value, 0 or more.deg_freedom1: The degrees of freedom of the numerator.deg_freedom2: The degrees of freedom of the denominator.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
When to use it
F.DIST gives the chance of a ratio of two variances of x or less (with TRUE) in the F-distribution, or the height of its curve.
Examples
Below 15.2069 with 6 and 4 degrees of freedom
A B C D E 1 x df1 df2 2 15.2069 6 4 0.99 In E2:
=F.DIST(A2, B2, C2, TRUE)→ 0.99
Common mistakes
- p-values. For the p-value of an F statistic, use F.DIST.RT.
F.DIST 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
- Danish: F.FORDELING
- Dutch: F.VERD
- Finnish: F.JAKAUMA
- French: LOI.F.N
- German: F.VERT
- Hungarian: F.ELOSZL
- Italian: DISTRIBF
- Norwegian: F.FORDELING
- Polish: ROZKŁ.F
- Portuguese (Brazil): DIST.F
- Portuguese (Portugal): DIST.F
- Russian: F.РАСП
- Spanish: DISTR.F.N
- Swedish: F.FÖRD
- Turkish: F.DAĞ
Related functions
- F.DIST.RT: The right tail of the F-distribution: the chance of a ratio greater than x. This is the p-value of an F statistic.
- F.INV: The value below which a given share of the F-distribution falls.
- F.TEST: The F-test: the chance that two samples would have variances this different if their populations varied equally. Two-tailed.