FISHERINV Function

Returns the inverse of the Fisher transformation.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number from −1 to 1

Want to practice FISHERINV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

FISHERINV converts a Fisher z value back into a correlation between −1 and 1: (e^(2z) − 1) ÷ (e^(2z) + 1). If z = FISHER(r), then FISHERINV(z) = r.

It's the last step when you build a confidence interval for a correlation.

Syntax

=FISHERINV(y) Explain

Arguments

ArgumentRequired?What it does
yYesThe Fisher z value to convert back.

Examples

Example 1 — Turn the interval back into correlations

Fisher z for r = 0.6 with 28 pairs, plus and minus 1.96 standard errors.

B6fx=FISHERINV(B4-1.96*B5)
AB
1MeasureValue
2Correlation (r)0.6
3Pairs (n)28
4Fisher z0.6931
5Std error0.2
6Lower 95%0.2924
7Upper 95%0.7951
=FISHERINV(B4-1.96*B5) Explain

The 95% confidence interval for the correlation is 0.29 to 0.80.

Example 2 — Round trip

FISHERINV undoes FISHER.

=FISHERINV(FISHER(0.6)) Explain

Returns 0.6.

Common mistakes

  • #VALUE! y isn't a number.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.