FISHERINV (Number) FISHERINV (Number)
Number
Number Number
The Fisher-transformed value.
Returns
Number Number
The correlation coefficient corresponding to the given Fisher-transformed value.
Returns the inverse of the FISHER transformation. Given a Fisher-transformed value, this function returns the original correlation coefficient. The result is always strictly between -1 and 1.
Examples
FISHERINV (0)
FISHERINV (0)
Returns 0.
FISHERINV (1.10)
FISHERINV (1,10)
Returns roughly 0.8.