F.INV
TheF.INV
function in Google Sheets returns the inverse of the F probability distribution, given a probability and degrees of freedom. The F distribution is used in statistical analysis to compare the variances of two samples, and F.INV is used to find the value at which a given probability level is exceeded.
 How to use
F.INV
formula?  Examples of using
F.INV
formula F.INV
formula not working? Similar formulas to
F.INV
Usage
Use the F.INV
formula with the syntax shown below, it has 3 required parameters:
 probability (required):
The probability at which to evaluate the distribution. Must be between 0 and 1.  degrees_freedom1 (required):
The number of degrees of freedom in the numerator of the F distribution. Must be a positive integer.  degrees_freedom2 (required):
The number of degrees of freedom in the denominator of the F distribution. Must be a positive integer.
Examples
Here are a few example use cases that explain how to use theF.INV
formula in Google Sheets.
Find critical Fvalue for ANOVA test
When performing an analysis of variance (ANOVA) test, the Fvalue is used to determine if there is a significant difference between group means. By using F.INV with a probability of 0.05 and the appropriate degrees of freedom, you can find the critical Fvalue for the test.
Calculate confidence interval for regression slope
When performing a linear regression, the Fvalue is used to calculate the confidence interval for the slope of the regression line. By using F.INV with a probability of 0.05 and the appropriate degrees of freedom, you can find the critical Fvalue to use in the calculation.
Calculate pvalue for Ftest
When comparing the variances of two samples using an Ftest, the pvalue is used to determine if the difference between the variances is significant. By using F.INV with the appropriate degrees of freedom and the observed Fvalue, you can calculate the pvalue for the test.
Common Mistakes
F.INV
not working? Here are some common mistakes people make when using the F.INV
Google Sheets Formula:
Incorrect probability value
The probability value should be between 0 and 1. Double check that the value entered is within this range.
Invalid degrees of freedom
The degrees of freedom should be positive integers. Ensure that the values entered are valid and within the allowable range.
Incorrect order of degrees of freedom
Ensure that the degrees of freedom are entered in the correct order. degrees_freedom1 should be the numerator degrees of freedom and degrees_freedom2 should be the denominator degrees of freedom.
Related Formulas
The following functions are similar to F.INV
or are often used with it in a formula:

F.DIST
The F.DIST function calculates the cumulative distribution function (CDF) of the Fdistribution. This function is commonly used in statistical analysis to determine the probability that two variances are from the same population. The result of F.DIST is the probability that the random variable of an Fdistribution is less than or equal to a specified value.

T.INV
The
T.INV
function returns the inverse of the Student's tdistribution for the provided probability and degrees of freedom. This function is commonly used to calculate a critical value from the tdistribution when working with small sample sizes. 
NORM.INV
The
NORM.INV
function returns the inverse of the cumulative normal distribution for a specified mean and standard deviation. It is commonly used in statistical analysis to find the value at which a specified percentage of observations occur below that value.
Learn More
You can learn more about the F.INV
Google Sheets function on Google Support.