The Excel FISHERINV Function

Related Function:
FISHER Function
Fisher Transformation

The Fisher Transformation is frequently used to test hypotheses on the correlation coefficient.

The formula for the Fisher Transformation is:

Fisher Transformation Function

and the Inverse Fisher Transformation is given by the formula:

Inverse Fisher Transformation Function

The inverse Fisher transformation function is shown in the graph below:

Plot of Inverse Fisher Trasformation
See the Wikipedia Fisher Transformation page for further details.

Function Description

The Excel Fisherinv function calculates the inverse of the Fisher Transformation and returns a value between -1 and +1.

The syntax of the function is:


Where y is the value for which you want to calculate the inverse of the Fisher Transformation.

Fisherinv Function Examples

In the spreadsheet below, the Excel Fisherinv Function is used to calculate the inverse of the Fisher Transformation for 3 different values.

1 =FISHERINV( -0.2 )
3 =FISHERINV( 2.8 )
1 -0.19737532
2 0
3 0.99263152

For further details and examples of the Excel Fisherinv function, see the Microsoft Office website.

Fisherinv Function Error

If you get an error from the Excel Fisherinv function, this is likely to be the #VALUE! error:

Common Error
#VALUE! - Occurs if the supplied value of y is non-numeric.