Documentation/Calc Functions/FISHERINV

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

FISHERINV

Category:

Statistical Analysis

Summary:

Returns the inverse of the Fisher transformation for a given number and creates a function close to a normal distribution.

Syntax:

FISHERINV(Number)

Returns:

Returns a real number which is the inverse of Fisher transformation value Number. The output ranges from -1(exclusive) to +1(exclusive), i.e. (-1,+1).

Arguments:

Number is a real number or a reference to the cell containing that number which is the value that is to undergo inverse transformation.

Additional details:

  • The formula for FISHERINV function is:
Fisherinv.png.png

where x is the Number.

  • The figure below illustrates the FISHERINV function:
FISHERINV function
  • The function has the same formula as the TANH function.
  • It is such that FISHERINV(FISHER(x)) = x.

Examples:

Formula Description Returns
=FISHERINV(0.8) The formula calculates the inverse Fisher transformation of 0.8. 0.664036770267849
=FISHERINV(1.8) The formula calculates the inverse Fisher transformation of 1.8. 0.946806012846268

Related LibreOffice functions:

FISHER

TANH

ODF standard:

Section 6.18.28, part 2

Equivalent Excel functions:

FISHERINV