Quick Navigation
FDIST Function
Summary
The FDIST function calculates the right-tailed F probability distribution, helping you compare variance between two datasets. This statistical tool is essential for hypothesis testing to determine if two populations have significantly different degrees of diversity.
Syntax
FDIST(x, deg_freedom1, deg_freedom2)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| x | Number |
Yes | Numeric value for F distribution evaluation |
| deg_freedom1 | Number |
Yes | Numerator degrees of freedom integer |
| deg_freedom2 | Number |
Yes | Denominator degrees of freedom integer |
Using the FDIST Function
FDIST is primarily used in statistical analysis to test equality of variances between two normally distributed populations. It calculates P(F > x) where F follows an F-distribution with specified degrees of freedom, making it valuable for ANOVA and other variance comparison tests.
Common FDIST Examples
Basic F Probability Calculation
=FDIST(15.20686486, 6, 4)Returns 0.01 - the right-tailed probability for F=15.21 with 6 and 4 degrees of freedom
Variance Comparison Test
=FDIST(C2, B2, B3)Tests if variance in dataset C differs significantly from reference variances in B2/B3
Quality Control Analysis
=FDIST(2.5, 10, 12)Evaluates if production line variance exceeds acceptable threshold (p-value=0.045)
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: Any argument is non-numeric
Solution: Ensure all inputs are valid numbers
#NUM!
Cause: x is negative or degrees of freedom out of range (1-10^10)
Solution: Verify x ≥ 0 and 1 ≤ df < 10^10
#NUM!
Cause: Degrees of freedom are non-integer
Solution: Use integer values or INT() function
Notes
- FDIST has been replaced by F.DIST.RT for better accuracy
- Non-integer degrees of freedom are automatically truncated
- Use for backward compatibility only in new spreadsheets
- Ideal for comparing test score variability between groups
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016
Not available in: Excel 2019+ (use F.DIST.RT), Excel 365 (use F.DIST.RT)
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007, Excel 2010, Excel 2013, Excel 2016