F.INVfunction 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
- Examples of using
F.INVformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
F.INVformula 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.
F.INVnot working? Here are some common mistakes people make when using the
F.INVGoogle 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:
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.INVfunction 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.INVfunction 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.