FINV
Formulas / FINVCalculate the inverse of the F probability distribution.
FINV(probability,degrees_freedom1,degrees_freedom2)
- probability - required, associated with the F cumulative distribution
- degrees_freedom1 - required
- degrees_freedom2 - required
Examples
=FINV(0.5, 5, 8)This will return the F-value for which the probability of obtaining a value less than or equal to it is 0.5, when the numerator has 5 degrees of freedom and the denominator has 8 degrees of freedom.
=FINV(0.95, 3, 6)The FINV function can also be used to calculate the probability of a F-value given the desired probability, numerator degrees of freedom, and denominator degrees of freedom. This example will return the probability of obtaining a F-value less than or equal to 0.95 when the numerator has 3 degrees of freedom and the denominator has 6 degrees of freedom.
=FINV(0.05, 10, 15)The FINV function can also be used to calculate the probability of an F-value given the desired alpha level, numerator degrees of freedom, and denominator degrees of freedom. For example, in a Sourcetable formula you can use the preceding formula. This will return the F-value for which the probability of obtaining a value less than or equal to it is 0.05, when the numerator has 10 degrees of freedom and the denominator has 15 degrees of freedom.
Summary
The FINV function is used to calculate the inverse of the F probability distribution with improved accuracy. The new F functions have been renamed to better reflect their usage.
- The FINV function returns the inverse of the F probability distribution, which is useful for calculating the critical value of the F-test.
- The F-test is used to compare the variability of two data sets.
Need help with Formulas?
Frequently Asked Questions
What is the FINV function?
What is an F-test?
Are there any new functions that provide improved accuracy over FINV?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.