# 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: and the Inverse Fisher Transformation is given by the formula: The inverse Fisher transformation function is shown in the graph below: 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:

FISHERINV( y )

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.

Formulas:
A
1=FISHERINV( -0.2 )
2=FISHERINV( 0 )
3=FISHERINV( 2.8 )
Results:
A
1-0.19737532
20
30.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.