Excel F.DIST Function

Description

The Excel F.DIST function returns the F probability distribution which is usually used to measure the degree of diversity between two data sets.

Syntax and arguments

Formula syntax

Arguments

Remarks

1. The function returns #VALUE! error value if any arguments of F.DIST function is a non-numeric value.

2. The function returns #NUM! error value when:

• X is negative;
• Either deg_freedom1 or deg_freedom2 < 1.

3. If deg_freedom1 or deg_freedom2 is not an integer, it will be truncated.

Version

Excel 2010 and later versions

Usage and Examples

Basic usage

For instance, in list C2:C4 contains arguments x, deg_freedom1 and deg_freedom2, to get the relative F probability by using cumulative distribution function or probability density function, please use the formula as these:

=F.DIST(C2,C3,C4,TRUE)   //Return cumulative distribution function

=F.DIST(C2,C3,C4,FALSE)   //Return probability density function

Press Enter key.

Other Functions:

• Excel COVARIANCE.P Function
  The Excel COVARIANCE.P function returns the population variance of two data sets which is used to determine the relationship between two data sets.

• Excel COVARIANCE.S Function
  The Excel COVARIANCE.P functionreturns the sample variance of two data sets.

• Excel EXPON.DIST Function
  EXPON.DIST function used in Excel 2010, returns the exponential distribution based on the given x value and the parameter of the distribution.

• Excel NORM.S.INV Function
  The NORM.S.INV calculates and returns the inverse of the standard normal cumulative distribution that has an arithmetic mean of 0 and standard deviation of 1 with a given probability.