FISHERINV

Name

Fisherinv

Description

Returns the inverse of the Fisher transformation for a specified value.

Syntax

FISHERINV(value)

Remarks

The argument is the specified numeric value.

Use this transformation when analyzing correlations between ranges or arrays of data. This function calculates the inverse of the Fisher transformation, so if y = FISHER(x), then FISHERINV(y) = x.

The inverse Fisher transformation is calculated as follows:where x is the value argument.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

FISHER(A43)
FISHER(R4C12)
FISHER(-0.65)=-0.7752987062