Excel > Function References > Statistical Functions

FISHERINV function

Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

Syntax

FISHERINV(y)

Argument	Description	Remarks
y	The value for which you want to perform the inverse of the transformation.	If this argument is nonnumeric, this function returns the #VALUE! error value.

General remarks

The equation for the inverse of the Fisher transformation is:

FISHERINV Equation

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

A	B
Formula	Description (Result)
=FISHERINV(0.972955)	Inverse of the Fisher transformation at 0.972955 (0.75)

See also
CORREL function
COVARIANCE.P function
COVARIANCE.S function
FISHER function
List of all functions (by category)

Share your feedback about this topic

Rate this content: