Jump to content

Documentation/Calc Functions/FISHER

From The Document Foundation Wiki

Function name:

FISHER

Category:

Statistical Analysis

Summary:

Calculates the Fisher transformation (also known as the Fisher z-transformation) for a given number, which is assumed to be a Pearson correlation coefficient. The sampling distribution of the transformed variable follows a normal distribution.

Syntax:

FISHER(Number)

Returns:

Returns a real number, which is the Fisher transformation of the given sample correlation coefficient value.

Arguments:

Number is a real number in the range (-1, 1), or a reference to a cell containing that number, which is the value to be transformed.

  • If Number is non-numeric, then FISHER reports a #VALUE! error.
  • If Number is less than or equal to -1.0, or greater than or equal to 1.0, then FISHER reports an invalid argument error (Err:502).

Additional details:

  • The formula for the FISHER function is:
[math]\displaystyle{ \text{FISHER}(r)~=~\frac{1}{2}\ln\left(\frac{1+r}{1-r} \right) }[/math]
where r is a correlation coefficient.
  • FISHER utilizes the same formula as the ATANH function.
  • The figure below illustrates the FISHER function:

Examples:

Formula Description Returns
=FISHER(A1) where cell A1 contains the value -0.8. Here the formula calculates the Fisher transformation of -0.8. -1.09861228866811
=FISHER(0) Here the formula calculates the Fisher transformation of 0. 0
=FISHER(0.8) Here the formula calculates the Fisher transformation of 0.8. 1.09861228866811

Related LibreOffice functions:

ATANH

FISHERINV

ODF standard:

Section 6.18.26, part 2

Related (or similar) Excel functions:

FISHER