Related Functions:

The F.DIST function returns the Probability Density Function or the Cumulative Distribution Function for the F Distribution. This function is frequently used used to measure the degree of diversity between two data sets.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.

Syntax

=F.DIST(x,deg_freedom1,deg_freedom2,cumulative)

Arguments

Argument Description
x The numeric value at which the function is to be evaluated – must be positive
deg_freedom1 An integer specifying the numerator degrees of freedom
deg_freedom2 An integer specifying the denominator degrees of freedom
cumulative A logical value that determines the form of the function

  TRUE calculate the cumulative distribution function
  FALSE calculate the probability density function

Examples

  A B C D
1 Data Description    
2 18.3589 Value at which to evaluate the function    
3 8 Numerator degrees of freedom    
4 4 Denominator degrees of freedom    
5        
6 Formula Result Notes
7 =F.DIST(A2,A3,A4,TRUE) 0.993337 F probability using the cumulative distribution function
8 =F.DIST(A2,A3,A4,FALSE) 0.000688 F probability using the probability density function

Usage note: Use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering college and determine if the variability in the females is different from that found in the males.

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the x, deg_freedom1 or deg_freedom2 arguments are non-numeric
#NUM! Occurs if either:

  the supplied x value is < 0
  the the supplied deg_freedom1 or the supplied deg_freedom2 argument is < 1