FINV

Formulas / FINV
Calculate 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.

Frequently Asked Questions

What is the FINV function?
The FINV function is a function used to calculate the inverse of the F probability distribution. This F probability distribution can be used in an F-test to determine if a population has a specific probability.
What is an F-test?
An F-test is a statistical test that compares the variability in two data sets.
Are there any new functions that provide improved accuracy over FINV?
Yes, there are new functions that may provide improved accuracy over FINV.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV