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

Search this site: Custom Search

Fisher Transformation The Fisher Transformation is frequently used to test hypotheses on the correlation coefficient. The formula for the Fisher Transformation is : This function is shown in the graph below: For more information, see the Wikipedia Fisher Transformation page

Basic Description

The Excel FISHER function calculates the Fisher Transformation for a supplied value.

The format of the function is :

Where x is the value at which you want to calculate the function.

Examples

The spreadsheet below shows examples of the Excel Fisher Function, used to calculate 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 Fisher function can be found on the Microsoft Office website.

Common Errors

If you get an error from your Excel Fisher function this is likely to be one of the following :