What is the syntax for FISHERINV in Excel?

The syntax for FISHERINV is: =FISHERINV(y)

What is the FISHER function in Excel?

FISHER performs Fisher's z-transformation on correlation coefficients, converting them to a normally distributed variable. This is essential for statistical tests involving correlations.

Why do I need Fisher transformation for correlations?

Correlation coefficients aren't normally distributed, making statistical tests unreliable. Fisher transformation normalizes them, allowing proper hypothesis testing and confidence intervals.

How do I use FISHER in correlation analysis?

Apply FISHER to correlation coefficients before statistical tests: =FISHER(CORREL(A:A,B:B)). Use FISHERINV to convert back to correlation scale after analysis.

What values can I use with FISHER?

FISHER accepts correlation coefficients between -1 and 1 (exclusive). Values of exactly -1 or 1 will cause errors since the transformation is undefined at these points.

Statistical

FISHERINV Function in Excel

Returns the inverse of the Fisher transformation.

Syntax

=FISHERINV(y)

Arguments

y (required): Value to inverse transform

Examples

=FISHERINV(0.973) - Inverse Fisher - Result: 0.75

FISHERINV for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

Must be numeric

Use cases

Correlation analysis
Statistical transformation
Confidence intervals

Frequently asked questions

What is the FISHER function in Excel? FISHER performs Fisher's z-transformation on correlation coefficients, converting them to a normally distributed variable. This is essential for statistical tests involving correlations.
Why do I need Fisher transformation for correlations? Correlation coefficients aren't normally distributed, making statistical tests unreliable. Fisher transformation normalizes them, allowing proper hypothesis testing and confidence intervals.
How do I use FISHER in correlation analysis? Apply FISHER to correlation coefficients before statistical tests: =FISHER(CORREL(A:A,B:B)). Use FISHERINV to convert back to correlation scale after analysis.
What values can I use with FISHER? FISHER accepts correlation coefficients between -1 and 1 (exclusive). Values of exactly -1 or 1 will cause errors since the transformation is undefined at these points.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.