Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

FINV

Calculates the inverse of the left-tailed F probability distribution. 

 

Sample Usage

FINV(0.55,2,3)
FINV(A2,A6,A3)

Syntax

FINV(probability, degrees_freedom1, degrees_freedom2)

  • probability - The probability associated with the left-tailed F probability distribution.
  • degrees_freedom1 - The numerator of the number of degrees of freedom.
  • degrees_freedom2 - The denominator of the number of degrees of freedom.

Examples

FINV(0.55,2,3) returns a value of 1.0543

Notes

  • All arguments must be numeric.
  • degrees_freedom1 and degrees_freedom2 must be greater than 1.
  • degrees_freedom1 and degrees_freedom2 are truncated to integer(s) if non-integer(s) are provided.