The Excel FDIST function calculates the (right-tailed) F Probability Distribution, which measures the degree of diversity between two data sets.
Syntax: FDIST( x, deg_freedom1, deg_freedom2 )
Where the function arguments are:
|x||–||The (positive) numeric value at which the function is to be evaluated|
|deg_freedom1||–||An integer specifying the numerator degrees of freedom|
|deg_freedom2||–||An integer specifying the denominator degrees of freedom|
If either deg_freedom1 or deg_freedom2 are decimal numbers, these are truncated to integers by Excel.
Fdist Function Example
The chart on the right shows the right-tailed F Probability Distribution with the numerator degrees of freedom equal to 1 and the denominator degrees of freedom equal to 2. If you want to use Excel to calculate the value of this function at x = 5, this can be done by the Fdist function, as follows:
This gives the result 0.154845745.
Fdist Function Common Errors
If you get an error from the Excel Fdist function this is likely to be one of the following :
|#NUM!||–||Occurs if either the supplied x value is < 0 or the supplied deg_freedom1 or the deg_freedom2 argument is < 1 or ≥ 10^10|
|#VALUE!||–||Occurs if any of the supplied arguments are non-numeric|