The FISHER function returns the Fisher transformation of a specified value.
This function is used in statistics to transform correlations to make their distribution closer to normal.
It can be useful in tasks related to correlation and regression.
Syntax
FISHER(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Number for which the Fisher transformation needs to be calculated |
Any real number in the range from −1 to 1 (excluding the boundaries) |
Example of use
Correlation coefficient conversion
=FISHER(0.75)
This formula calculates the Fisher transformation for a correlation coefficient of 0.75.
Result: approximately 0.973.
Using a cell reference
=FISHER(A2)
If cell A2 contains a correlation coefficient of 0.6, the function will return the Fisher transformation value (approximately 0.693).
Notes
–The Fisher transformation is calculated using the formula: 0.5 × ln((1 + x)/(1 − x)).
–If the value argument is −1 or 1, the function will return the #NUM! error.
–The result of the conversion can take any valid value from −∞ to +∞.