The Excel FISHERINV function calculates the inverse of the Fisher Transformation and returns a value between -1 and +1
Syntax: FISHERINV( y )
Where y is the value for which you want to calculate the inverse of the function.
The spreadsheet below shows examples of the Excel Fisherinv Function, used to calculate the inverse of the Fisher Transformation for 3 different values. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Fisherinv Function Common Error
If you get an error from the Excel Fisherinv function, this is likely to be the #VALUE! error:
|#VALUE!||–||Occurs if the supplied value of y is not recognised as a numeric value in Excel|