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

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

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel Web App
=F.INV(probability,deg_freedom1,deg_freedom2)
Hover argument names in the table for details.
Output typeNumber
Popularity4 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =F.INV() 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.xlsx — Coming soon ~ 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

معکوس توزیع احتمال F برای عبارت‌های بالا =F.INV(A2,A3,A4)

✦ Tips

  • If deg_freedom1 or deg_freedom2 is not an integer, it is truncated.

⚠ Common Errors

#VALUE! If any argument is nonnumeric, F.INV returns the #VALUE! error value.
Fix: مطمئن شوید همه آرگومان‌ها عددی هستند.
#NUM! If probability < 0 or probability > 1, F.INV returns the #NUM! error value. If deg_freedom1 < 1, or deg_freedom2 < 1, F.INV returns the #NUM! error value.
Fix: Correct the input value

⇄ Related Functions

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