Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
FISHERINV
Returns the inverse of the Fisher transformation.
Rarely usedDifficulty 1450 · AdvancedUsage rank #371 of 520
When to use it
Reverses the Fisher transformation: TANH(y), giving back a correlation coefficient.
The shape of it
- Syntax
=FISHERINV(y)
Worked examples
Round trip
=FISHERINV(0.549306144) → 0.5
Round trip.
One
=FISHERINV(1) → 0.761594156
A transformed value of 1.
Zero
=FISHERINV(0) → 0
Zero.
Worth knowing
- Apply to both ends of a transformed interval to get an interval for r.
- Same as TANH.
- Always returns a value between -1 and 1.
Where it goes wrong
- Text input returns #VALUE!.
- Large inputs saturate at ±1.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.