[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

FINV

Syntax:

FINV ( probability , degrees-freedom-1 , degrees-freedom-2 )

Description: Computes the inverse of the F probability distribution. Given a value for probability, FINV seeks that value x such that FDIST(x, degrees-freedom1, degrees-freedom2) = probability. Thus, precision of FINV depends on precision of FDIST. FINV uses an iterative search technique.

Arguments:

Name

Type

Description

probability

number

A probability associated with the F cumulative distribution.

degrees-freedom-1

number

The number of degrees of freedom for the numerator, truncated to an integer.

degrees-freedom-2

number

The number of degrees of freedom for the denominator, truncated to an integer.

 

Return Type and Value: number – The inverse of the F probability distribution.

However, if

probability < 0 or probability > 1, #NUM! is returned.

degrees-freedom-1 < 1 or degrees-freedom-1 ≥ 1010, #NUM! is returned.

degrees-freedom-2 < 1 or degrees-freedom-2 ≥ 1010, #NUM! is returned.

The search has not converged after some implementation-defined number of iterations, #N/A is returned

[Example:

FINV(0.5,3,4) results in 0.940534076

end example]