Related Functions:

The F.DIST.RT function returns the (right-tailed) F Probability Distribution, which measures the degree of diversity between two data sets.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The F.DIST.RT function replaces the FDIST function included in earlier versions of Excel.

Syntax

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

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

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.RT(A2,A3,A4) 0.006663 F probability distribution for the supplied terms

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 supplied arguments are non-numeric
#NUM! Occurs if either:

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