Home › Functions › Statistical › =F.DIST.RT()
Statistical Excel 2010 ◉ 43 views

=F.DIST.RT()

rticle describes the formula syntax and usage of the F.DIST.RT function in Microsoft Excel. Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. 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 2016
=F.DIST.RT(x,deg_freedom1,deg_freedom2)
Hover argument names in the table for details.
Output typeNumber
Popularity7 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =F.DIST.RT() 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)
Download F.DIST.RT.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
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.

▣ Examples

▦ Data
CellValueDescription
A2 15.2068649 Value at which to evaluate the function
A3 6 Numerator degrees of freedom
A4 4 Denominator degrees of freedom
A5 15.2068649 Value at which to evaluate the function
A6 6 Numerator degrees of freedom
A7 4 Denominator degrees of freedom
F probability distribution for the terms above. =F.DIST.RT(A2,A3,A4)
Result: 0.01

§ Remarks

  • If any argument is nonnumeric, F.DIST.RT returns the #VALUE! error value.
  • If x is negative, F.DIST.RT returns the #NUM! error value.
  • If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.
  • If deg_freedom1 < 1 F.DIST.RT returns the #NUM! error value.
  • If deg_freedom2 < 1 F.DIST.RT returns the #NUM! error value.
  • F.DIST.RT is calculated as F.DIST.RT=P( F>x ), where F is a random variable that has an F distribution with deg_freedom1 and deg_freedom2 degrees of freedom.

✦ Tips

  • If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.
  • F.DIST.RT is calculated as F.DIST.RT=P( F>x ), where F is a random variable that has an F distribution with deg_freedom1 and deg_freedom2 degrees of freedom.

⚠ Common Errors

#VALUE! If any argument is nonnumeric, F.DIST.RT returns the #VALUE! error value.
Fix: همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید.
#NUM! If x is negative, F.DIST.RT returns the #NUM! error value. If deg_freedom1 < 1 F.DIST.RT returns the #NUM! error value. If deg_freedom2 < 1 F.DIST.RT returns the #NUM! error value.
Fix: Correct the input value

⇄ Related Functions

=LINEST() The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line. You can also combine LINEST with other functions to calculate the statistics for other types of models that are linear in the unknown parameters, including polynomial, logarithmic, exponential, and power series. Because this function returns an array of values, it must be entered as an array formula. Instructions follow the examples in this article. The equation for the line is: y = mx + b –or– y = m1x1 + m2x2 + ... + b if there are multiple ranges of x-values, where the dependent y-values are a function of the independent x-values. The m-values are coefficients corresponding to each x-value, and b is a constant value. Note that y, x, and m can be vectors. The array that the LINEST function returns is {mn,mn-1,...,m1,b}. LINEST can also return additional regression statistics. =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. =F.INV.RT() Returns the inverse of the (right-tailed) F probability distribution. If p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x. The F distribution can be used in an F-test that compares the degree of variability in two data sets. For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have a similar degree of income diversity.

💬 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!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.