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:
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
See Also