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
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
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
- Use FISHER function to return the Fisher transformation.
