Syntax
=F.INV(probability, deg_freedom1, deg_freedom2)Arguments
| Argument | Required | Description |
|---|---|---|
probability | Required | The probability, between 0 and 1 |
deg_freedom1 | Required | Numerator degrees of freedom |
deg_freedom2 | Required | Denominator degrees of freedom |
How to use F.INV
F.INV takes 3 required arguments. Type =F.INV( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=F.INV(0.01, 6, 4)Result Related statistical functions
- DEVSQReturns the sum of squared deviations of the numbers from their mean.
- EXPON.DISTReturns the exponential distribution.
- F.DISTReturns the left tailed F probability distribution.
- F.DIST.RTReturns the right tailed F probability distribution.
- F.INV.RTReturns the inverse of the right tailed F distribution.
- F.TESTReturns the two tailed probability of an F test that two samples have the same variance.
- FISHERReturns the Fisher transformation of a value between -1 and 1.
- FISHERINVReturns the inverse of the Fisher transformation.
- FORECASTPredicts a value for x from the straight line that best fits known x and y values.