# Documentation/Calc Functions/FISHER

Jump to navigation Jump to search

FISHER

## Category:

Statistical Analysis

## Summary:

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

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.

## 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

FISHER