Returns the Fisher transformation for the given number and creates a function close to a normal distribution.
Returns a real number which is the Fisher transformation for a given sample correlation coefficient Number.
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.
- 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.
|=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:
Equivalent Excel functions: