Formulas > =FISHERINV()

How To Use FISHERINV() Function in Google Sheets


Returns the inverse Fisher transformation of a specified value.

Common questions about the FISHERINV formula include:
- What does it do and how do I use it?
- How can it be used in combination with other formulas?

The FISHERINV formula can be used to calculate the inverse of the Fisher transformation, which is useful for transforming correlations into something easier to compare between different data sets.

The FISHERINV formula is often mistyped as FISHERMET or FISHEROUV. Other misspellings are FISHREINV, FSHERINV, FISHERIVN.

Common ways the FISHERINV formula is used inappropriately include using it in place of other statistical transformation formulas, such as FISHERZ or FISHERT, and using it to transform values that are not correlations.

Common pitfalls when using the FISHERINV formula include forgetting to enter the function properly within the required parentheses and using incorrect or missing arguments.

Common mistakes when using the FISHERINV formula include forgetting to include the number argument at all, and incorrectly entering one of the other arguments.

Common misconceptions people might have with the FISHERINV formula include that it is the same as the FISHERZ transformation and that it can be used to transform any numerical value.

How To Actually Use FISHERINV() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the FISHERINV() formula:

43 statistical formulas in excel 2016

mula in excel | excel formulas This video is about how to create 43 Statistical Functions with Examples in MS Excel Office Spreadsheet 2016 - Part 3.

Generate a FISHERINV() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.