Home » Excel-Built-In-Functions » Excel-Statistical-Functions » Excel-Fisherinv-Function

Search this site: Custom Search Basic Description The Excel FISHERINV function calculates the inverse of the Fisher Transformation and returns a value between -1 and +1

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 inverse Fisher transformation function is shown in the graph below: For more information, see the Wikipedia Fisher Transformation page

The format of the function is :

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

Examples

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.

Further information and examples of the Excel Fisherinv function can be found on the Microsoft Office website.

Common Errors

If you get the #VALUE! error from your Excel Fisherinv function this is likely to be because the supplied value of y is not recognised as a numeric value in Excel.