Statistical
Excel 2010
◉ 23 views
=F.DIST()
Returns the F probability distribution. You can 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 high school, and determine if the variability in the females is different from that found in the males.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel Web App
=F.DIST(x,deg_freedom1,deg_freedom2,cumulative)
Hover argument names in the table for details.
Output typeStatistical
Popularity5 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =F.DIST() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
x |
Number | Required | The value at which to evaluate the function. |
deg_freedom1 |
Number | Required | The numerator degrees of freedom. |
deg_freedom2 |
Number | Required | The denominator degrees of freedom. |
cumulative |
Logical | Required | A logical value that determines the form of the function. If cumulative is TRUE, F.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. |
▣ Examples
▦ Data
| Cell | Value | Description |
|---|---|---|
A2 |
15.2069 | Value at which to evaluate the function |
A3 |
6 | Numerator degrees of freedom |
A4 |
4 | Denominator degrees of freedom |
A5 |
15.2069 | Value at which to evaluate the function |
A6 |
6 | Numerator degrees of freedom |
A7 |
4 | Denominator degrees of freedom |
F probability using the cumulative distribution function (TRUE cumulative argument).
=F.DIST(A2,A3,A4,TRUE)
Result:
0.99
F probability using the probability density function (FALSE cumulative argument).
=F.DIST(A2,A3,A4,FALSE)
Result:
0.0012238
§ Remarks
- 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 or deg_freedom2 is not an integer, it is truncated.
- If deg_freedom1 < 1, F.DIST returns the #NUM! error value.
- If deg_freedom2 < 1, F.DIST returns the #NUM! error value.
✦ Tips
- If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.
⚠ Common Errors
#VALUE!
If any argument is nonnumeric, F.DIST returns the #VALUE! error value.
Fix: همه آرگومانها را بررسی کنید و مطمئن شوید مقدار عددی دارند؛ ورودیهای متنی را اصلاح کنید.
#NUM!
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.
Fix: Correct the input value
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!