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:

FISHER Function - How to use FISHER Function in Excel

Syntax:  =FISHER(A2)

Result: 0.972955075

FISHER Function in Excel - How to use FISHER Function in Excel

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:
    FISHER Function in Excel - How to use FISHER Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *