Documentation/Calc Functions/FISHER

Function name:
FISHER

Category:
Statistical Analysis

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

Syntax:
FISHER(Number)

Returns:
Returns a real number which is the Fisher transformation for a given sample correlation coefficient Number.

Arguments:
Number is a real number between 0(exclusive) and 1(exclusive) or a reference to the cell containing that umber which is the value to be transformed.


 * If Number is greater than or equal to 1 or less than or equal to 0, then the function returns an error value.

Additional details:

 * The formula for the FISHER function is:

where n is the Number.
 * The figure below illustrates the FISHER function:


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

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

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

ODF standard:
Section 6.18.26, part 2

Equivalent Excel functions:
FISHER