How to use the FDIST function
Author: Oscar Cronquist Article last updated on May 11, 2022
The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is replaced with the F.DIST and F.DIST.RT function which was introduced in Excel 2010.
Formula in cell C7:
=FDIST(C3,C4,C5)
Excel Function Syntax
FDIST(x, deg_freedom1, deg_freedom2)
Arguments
| x | Required. |
| deg_freedom1 | Required. Degrees of freedom (numerator). |
| deg_freedom2 | Required. Degrees of freedom (denominator). |
Comments
The FDIST function returns
- #VALUE! error value if any argument is non-numeric.
- #NUM! error value if:
- x < 0 (zero)
- deg_freedom1 < 1
- deg_freedom1 >= 10^10
- deg_freedom2 < 1
- deg_freedom1 >= 10^10
deg_freedom1 and deg_freedom2 will be converted into integers if they are not.
Functions in 'Compatibility' category
The FDIST function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form