Documentation/Calc Functions/FISHER

From The Document Foundation Wiki
Jump to navigation Jump to search


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:
Fishere.png.png

where n is the Number.

  • The figure below illustrates the FISHER function:
FISHER function
  • The function has the same formula as the ATANH function.

Examples:

Formula Description Returns
=FISHER(0.8) The formula calculates the Fisher transformation of 0.8. 1.09861228866811
=FISHER(1.8) The function returns an error value whenever Number is greater than or equal to 1. Err:502

Related LibreOffice functions:

FISHERINV

ATANH

ODF standard:

Section 6.18.26, part 2

Equivalent Excel functions:

FISHER