September 17, 2021

# How to use FISHER Function in Excel

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: READ:  How to use QUARTILE.EXC Function in Excel #### Excel

View all posts by Excel →