Spread Formula Reference
FISHERINV
Formula Functions > Functions D to G > FISHERINV

This function returns the inverse of the Fisher transformation for a specified value.

Syntax

FISHERINV(value)

Arguments

The argument is the specified numeric value.

Remarks

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:

FISHERINV Equation

where y is the value argument.

Data Types

Accepts numeric data. Returns numeric data.

Examples

FISHERINV(A43)

FISHERINV(R4C12)

FISHERINV(0.56) gives the result 0.5079774329

Version Available

This function is available in product version 1.0 or later.

See Also

FISHER | Statistical Functions