Syntax
FISHERINV(y)
| Parameter | Description |
|---|---|
| y | Parameter of the FISHERINV function. |
Examples
Inverse of Fisher transform
Formula
=FISHERINV(0.973)
Returns approximately 0.75 — converting the Fisher z-value back to the original correlation coefficient.
Confidence interval lower bound
Formula
=FISHERINV(FISHER(0.85) - 1.96/SQRT(47))
Computes the lower bound of a 95% confidence interval for a correlation of 0.85 from a sample of 50 (n-3=47).
Average correlation
Formula
=FISHERINV(AVG(FISHER(0.6), FISHER(0.8), FISHER(0.7)))
The correct way to average correlations: transform to z-space, average, then transform back. Direct averaging of correlations is biased.
Common Errors
#VALUE!
Non-numeric input.
#NUM!
Extremely large input values may cause overflow, though in practice this is rare.
Tips
Result is always between -1 and 1
FISHERINV always returns a value in (-1, 1), corresponding to a valid correlation coefficient.
Pair with FISHER
FISHERINV(FISHER(x)) = x. They are exact inverses. Always use FISHER to transform, do your calculations, then use FISHERINV to transform back.
Average correlations correctly
Never average correlation coefficients directly. Transform with FISHER first, average the z-values, then use FISHERINV. Direct averaging underestimates the true average correlation.
Try FISHERINV in Viztab
Import your data and use FISHERINV with 370+ other formulas. No signup required.
Open Viztab