Advanced Excel Statistical - F.DIST Function

Description

The F.DIST function returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity.

Syntax

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

Arguments

Argument	Description	Required/ Optional
X	The value at which to evaluate the function.	Required
Deg_freedom1	The numerator degrees of freedom.	Required
Deg_freedom2	The denominator degrees of freedom.	Required
Cumulative	A logical value that determines the form of the function. If cumulative is TRUE, F.DIST returns the cumulative distribution function. If cumulative is FALSE, F.DIST returns the probability density function.	Required

Notes

If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.
If any argument is nonnumeric, F.DIST returns the #VALUE! error value.
If x is negative, F.DIST returns the #NUM! error value.
If deg_freedom1 < 1, F.DIST returns the #NUM! error value.
If deg_freedom2 < 1, F.DIST returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm