Excel F.INV Function
Description
The Excel F.INV function returns the inverse of F probability distribution. If p (probability) = F.DIST(x,…), then F.INV(p,…)= x.
Syntax and arguments
Formula syntax
Arguments
|
Remarks
1. The function returns #VALUE! error value if any arguments of F.INV function is a non-numeric value.
2. The function returns #NUM! error value when:
- Probability is < 0 or > 1;
- Either deg_freedom1 or deg_freedom2 is < 1.
3. If deg_freedom1 or deg_freedom2 is not an integer, it will be truncated.
Version
Excel 2010 and later versions
Usage and Examples
Basic usage
For instance, in list C2:C4 contains arguments probability, deg_freedom1, and deg_freedom2, to get the relative inverse of the F probability, please use the formula as these:
=F.INV(C2,C3,C4)
Press Enter key. 
Other Functions:
-
Excel COVARIANCE.P Function
The Excel COVARIANCE.P function returns the population variance of two data sets which is used to determine the relationship between two data sets.
-
Excel FDIST Function
The Excel FDIST Function returns the (right-tailed) F probability distribution which is usually used to measure the degree of diversity between two data sets.
-
Excel EXPON.DIST Function
EXPON.DIST function used in Excel 2010, returns the exponential distribution based on the given x value and the parameter of the distribution.
-
Excel F.DIST Function
The Excel F.DIST function returns the F probability distribution which is usually used to measure the degree of diversity between two data sets.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
