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

`=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.

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.

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.

An F-test is a statistical test that compares the variability in two data sets.

Yes, there are new functions that may provide improved accuracy over FINV.

Drop CSV