F.INV

Formulas / F.INV
Calculate the inverse of the F probability distribution.
=F.INV(probability,deg_freedom1,deg_freedom2)
  • probability - required, associated with the F cumulative distribution
  • deg_freedom1 - required, numerator degrees of freedom
  • deg_freedom2 - required, denominator degrees of freedom

Examples

  • =F.INV( 0.9, 2, 5 )

    The function evaluates to 3.779716079 if the probability is 0.9 and the numerator and denominator degrees of freedom are 2 and 5.


Summary

The F.INV function is used to calculate the inverse of a F probability distribution, which is a measure of variance between two populations. It is an important tool for statistical analysis.

  • The F.INV function is primarily used in an F-test, which is a statistical test that is used to compare the variability between two population sets.
  • When used, the F.INV function returns the inverse of the F probability distribution.

Frequently Asked Questions

What is the F.INV function?
The F.INV function is a statistical function that calculates the inverse of the F probability distribution. This probability distribution is used for comparing the variability of two different data sets.
What is the purpose of the F.INV function?
The F.INV function is used to test whether two data sets have the same variability, or how much variability is present in each data set.
What type of data can be used with the F.INV function?
The F.INV function can be used with any type of numerical data, such as continuous or discrete data.
How is the F.INV function used?
The F.INV function is typically used in conjunction with the F-test. The F-test compares the variability of two data sets and the F.INV function calculates the inverse of the F probability distribution. The F.INV function is used to determine the probability that the two data sets have the same variability.
What is the output of the F.INV function?
The output of the F.INV function is a probability value that indicates the likelihood that the two data sets have the same variability.

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