Menu
EXCEL F.DIST FUNCTION
Excel F.DIST Function Introduction
The Excel F.DIST function computes the F Distribution’s Probability Density Function or Cumulative Distribution Function. This function is commonly used to compare the degree of diversity between two data sets. Because the function is new to Excel 2010, it is not available in previous versions of Excel.
Description of Excel F.DIST Function
Syntax :
=F.DIST( x, deg_freedom1, deg_freedom2, cumulative )
Parameters :
- cumulative-a logical argument indicating the type of F Distribution to be calculated. This could be either:
TRUE-Utilize the cumulative distribution function.
True or false: Be using the probability density function.
X :
- The (positive) numerical value at which the function should be evaluated.
Deg freedom1 :
- An integer indicating the degrees of freedom in the numerator.
Deg freedom2 :
- An integer that specifies the degrees of freedom in the denominator.
Cumulative :
- A logical argument indicating the type of F Distribution to be calculated. This could be either:
- TRUE – Utilize the cumulative distribution function.
- FALSE – Be using the probability density function.
Step By Step Guide of F.DIST Function
Example :
The probability density function for the F Distribution is depicted on the right, with the numerator degrees of freedom equal to 2 and the denominator degrees of freedom equal to 5.
If you want to calculate the value of this function at x = 1, you can use the F.Dist function in Excel, as seen below: =F.DISTANCE ( 1, 2, 5, FALSE ) This yields the value 0.308000822.
Key Points
- #NUM! – This error occurs if either the supplied value of x is 0 or the supplied deg freedom1 or deg freedom2 is 1.
- #VALUE! – This error occurs if any of the supplied arguments is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
