The FISHER function returns the Fisher transformation at x. This transformation produces a Function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.
Syntax:= FISHER(x)
The FISHER function syntax has the following arguments:
X: Required. A numeric value for which you want the transformation.
Example: Let’s look at some Excel FISHER function examples and explore how to use the FISHER function as a worksheet function in Microsoft Excel:
Syntax: =FISHER(A2)
Result: 0.972955075
Based on the Excel spreadsheet above, the following FISHER examples would return:
Syntax: =FISHER(A3)
Result: 1.256152812
Syntax: =FISHER(A4)
Result: -1.47221949
Syntax: =FISHER(A5)
Result: -0.255412812
Syntax: =FISHER(A6)
Result: 1.098612289
Syntax: =FISHER(A7)
Result: 0.549306144
Note:
- If x is nonnumeric, FISHER returns the #VALUE! error value.
- If x ≤ -1 or if x ≥ 1, FISHER returns the #NUM! error value.
-
The equation for the Fisher transformation is:
