FDIST function
FDIST returns the right-tail probability of the F distribution, the p-value for an F statistic. It still works, but F.DIST.RT supersedes it for new workbooks.
Example
Read it as a sentence: find the right-tail F distribution probability at D1 (which is empty, so counted as 0) with 2 and 10 degrees of freedom.
Excel shows 1
D
1
Data
Syntax
FDIST(x, deg_freedom1, deg_freedom2)
-
x(required) - The F value, 0 or more.
-
deg_freedom1(required) - Numerator degrees of freedom.
-
deg_freedom2(required) - Denominator degrees of freedom.
Returns: Right-tail probability of the F distribution.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FDIST(3,2,10) | 0.095367432 | Working example |
=FDIST("3",2,10) | 0.095367432 | Text-number in first arg |
=FDIST({3,3},2,10) | 0.095367432 | Array in first arg (lifts, spills) |
=FDIST(Data!D1,2,10) | 1 | Blank cell as first arg |
=FDIST("abc",2,10) | #VALUE! | Non-numeric text in first arg |
=FDIST(NA(),2,10) | #N/A | Error in first arg |
=FDIST(-1,2,10) | #NUM! | Negative x |
=FDIST(3,0,10) | #NUM! | Df1 0 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by F.DIST.RT; use that in new workbooks.
- Right-tail only; F.DIST gives the cumulative form.
Where it works
- Excel
- FDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .