Excel FISHERINV Function

What is FISHERINV function in Excel?


The FISHERINV function is one of the Statistical functions of Excel.

It returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x.

We can find this function in Statistical category of insert function Tab.

How to use FISHERINV function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select FISHERINV function.

6. Then select ok.

7. In the function arguments Tab you will see FISHERINV function.

8. Y is the value for which you want to perform the inverse of the transformation.

9. You will see the results in the formula result section.

Examples of FISHERINV function in Excel

FISHERINV related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *