Home › Functions › Statistical › =F.INV.RT()
Statistical Excel 2010 ◉ 17 views

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

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=F.INV.RT(probability,deg_freedom1,deg_freedom2)
Hover argument names in the table for details.
Output typeNumber
Popularity6 / 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.INV.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.INV.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
probability Number Required A probability associated with the F cumulative distribution.
deg_freedom1 Number Required The numerator degrees of freedom.
deg_freedom2 Number Required The denominator degrees of freedom.

▣ Examples

▦ Data
CellValueDescription
A2 0.01 Probability associated with the F cumulative distribution
A3 6 Numerator degrees of freedom
A4 4 Denominator degrees of freedom
A5 0.01 Probability associated with the F cumulative distribution
A6 6 Numerator degrees of freedom
A7 4 Denominator degrees of freedom
Inverse of the F probability distribution for the terms above =F.INV.RT(A2,A3,A4)
Result: 15.20686

§ Remarks

  • If any argument is non-numeric, F.INV.RT returns the #VALUE! error value.
  • If Probability is < 0 or probability is > 1, F.INV.RT returns the #NUM! error value.
  • If Deg_freedom1 or Deg_freedom2 is not an integer, it is truncated.
  • If Deg_freedom1 is < 1, or Deg_freedom2 is < 1, F.INV.RT returns the #NUM! error value.
  • If Deg_freedom2 is < 1 or Deg_freedom2 is ≥ 10^10, F.INV.RT returns the #NUM! error value.
  • F.INV.RT can be used to return critical values from the F distribution. For example, the output of an ANOVA calculation often includes data for the F statistic, F probability, and F critical value at the 0.05 significance level. To return the critical value of F, use the significance level as the probability argument to F.INV.RT.
  • Given a value for probability, F.INV.RT seeks that value x such that F.DIST.RT(x, deg_freedom1, deg_freedom2) = probability. Thus, precision of F.INV.RT depends on precision of F.DIST.RT. F.INV.RT uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.

✦ Tips

  • If Deg_freedom1 or Deg_freedom2 is not an integer, it is truncated.
  • F.INV.RT can be used to return critical values from the F distribution. For example, the output of an ANOVA calculation often includes data for the F statistic, F probability, and F critical value at the 0.05 significance level. To return the critical value of F, use the significance level as the probability argument to F.INV.RT.

⚠ Common Errors

#VALUE! If any argument is non-numeric, F.INV.RT returns the #VALUE! error value.
Fix: همه آرگومان‌ها را بررسی کنید و مقدار عددی وارد کنید.
#NUM! If Probability is < 0 or probability is > 1, F.INV.RT returns the #NUM! error value. If Deg_freedom1 is < 1, or Deg_freedom2 is < 1, F.INV.RT returns the #NUM! error value. If Deg_freedom2 is < 1 or Deg_freedom2 is ≥ 10^10, F.INV.RT returns the #NUM! error value.
Fix: Correct the input value
#N/A If the search has not converged after 64 iterations, the function returns the #N/A error value.
Fix: مقادیر ورودی را بررسی کنید یا با مقادیر probability متفاوت دوباره تلاش کنید.

⇄ Related Functions

=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. =F.INV() Returns the inverse of the F probability distribution. If p = F.DIST(x,...), then F.INV(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.