September 17, 2021

How to use FISHERINV Function in Excel

The FISHERINV function returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

Syntax:= FISHERINV(y)

The FISHERINV function syntax has the following arguments:

  • Y    Required. The value for which you want to perform the inverse of the transformation.

Example: Let’s look at some Excel FISHERINV function examples and explore how to use the FISHERINV function as a worksheet function in Microsoft Excel:

FISHERINV Function - How to use FISHERINV Function in Excel

Syntax:  =FISHERINV(A2)

Result: 0.749999967

FISHERINV Function in Excel 1 - How to use FISHERINV Function in Excel

Based on the Excel spreadsheet above, the following FISHERINV examples would return:

Syntax: =FISHERINV(A3)
Result: 0.84828364

Syntax: =FISHERINV(A4)
Result: 0.578363413

Syntax: =FISHERINV(A5)
Result: -0.998177898

Syntax: =FISHERINV(A6)
Result: 0.635148952

Syntax: =FISHERINV(A7)
Result: 0.852477704

Note:

  • If y is nonnumeric, FISHERINV returns the #VALUE! error value.
  • The equation for the inverse of the Fisher transformation is:
    FISHERINV Function in Excel - How to use FISHERINV Function in Excel

READ:  How to use KURT Function in Excel

Leave a Reply

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