# F.INV

The `F.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.

## Usage

Use the `F.INV` formula with the syntax shown below, it has 3 required parameters:

Parameters:
1. probability (required):
The probability at which to evaluate the distribution. Must be between 0 and 1.
2. degrees_freedom1 (required):
The number of degrees of freedom in the numerator of the F distribution. Must be a positive integer.
3. 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 the `F.INV` formula in Google Sheets.

### Find critical F-value for ANOVA test

When performing an analysis of variance (ANOVA) test, the F-value 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 F-value for the test.

### Calculate confidence interval for regression slope

When performing a linear regression, the F-value 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 F-value to use in the calculation.

### Calculate p-value for F-test

When comparing the variances of two samples using an F-test, the p-value 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 F-value, you can calculate the p-value 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.

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 F-distribution. 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 F-distribution is less than or equal to a specified value.

• `T.INV`

The `T.INV` function returns the inverse of the Student's t-distribution for the provided probability and degrees of freedom. This function is commonly used to calculate a critical value from the t-distribution 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.

You can learn more about the `F.INV` Google Sheets function on Google Support.