The 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.

FISHERINV takes 1 required argument and no optional arguments:

Syntax: FISHERINV(y)

#1)
Using the FISHERINV function:
#2)
The arguments for the FISHERINV function are:
Argument Required? Description
y Required The value for which you want to perform the inverse of the transformation.
#3)
One thing:
If y is nonnumeric, FISHERINV returns the #VALUE! error value.

Summary

The FISHERINV function returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data.
comments powered by Disqus