Quick Navigation
F.DIST Function
Summary
The F.DIST function calculates the F probability distribution, helping you compare variance between two datasets. It's essential for statistical analysis to test if two groups have significantly different spreads or dispersions.
Syntax
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| x | Number |
Yes | The numeric value at which to evaluate the F distribution |
| deg_freedom1 | Number |
Yes | Numerator degrees of freedom (must be ≥ 1) |
| deg_freedom2 | Number |
Yes | Denominator degrees of freedom (must be ≥ 1) |
| cumulative | Boolean |
Yes | TRUE for cumulative distribution function, FALSE for probability density function |
Using the F.DIST Function
Use F.DIST when conducting F-tests to compare variances between two populations. Set cumulative to TRUE for the area under the curve up to value x, or FALSE for the exact probability density at point x.
Common F.DIST Examples
Cumulative F Distribution
=F.DIST(15.2069, 6, 4, TRUE)Returns 0.99 - Cumulative probability up to value 15.2069 with 6 and 4 degrees of freedom
Probability Density Function
=F.DIST(15.2069, 6, 4, FALSE)Returns 0.0012238 - Probability density at exact value 15.2069
Variance Comparison Test
=F.DIST(VarianceRatio, df1, df2, TRUE)Tests if two datasets have significantly different variances
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: x is negative
Solution: Ensure x value is positive
#NUM!
Cause: deg_freedom1 or deg_freedom2 < 1
Solution: Degrees of freedom must be 1 or greater
#VALUE!
Cause: Non-numeric arguments
Solution: All parameters must be numbers or TRUE/FALSE
#NUM!
Cause: Degrees of freedom not integers
Solution: Excel truncates decimals automatically
Notes
- If x ≤ 0, function returns 0 for cumulative=TRUE
- Degrees of freedom truncated to integers
- Ideal for comparing test score variability between groups
- Use F.DIST.RT for right-tail probabilities
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365, Excel Online
Not available in: Excel 2007, Excel 2003, Earlier versions
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+