Documentation/Calc Functions/FISHERINV

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:

where x is the Number.


 * The figure below illustrates the FISHERINV function:


 * The function has the same formula as the TANH function.


 * It is such that FISHERINV(FISHER(x)) = x.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/FISHER FISHER]

[[Special:MyLanguage/Documentation/Calc_Functions/TANH TANH]

ODF standard:
Section 6.18.28, part 2

Equivalent Excel functions:
FISHERINV