Excel functions / Statistics
FISHERINV function
Turns a Fisher-transformed value back into a correlation.
Syntax
=FISHERINV(y)
Arguments
y: The transformed value.
When to use it
FISHERINV turns a Fisher-transformed value back into a correlation, for example the ends of a confidence interval.
Examples
Back to the correlation
A B C 1 z 2 0.972955 0.75 In C2:
=FISHERINV(A2)→ 0.75
Common mistakes
- Order. Transform with FISHER, work out the interval, then come back with FISHERINV.
FISHERINV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: FISHERINV
- Danish: FISHERINV
- Dutch: FISHER.INV
- Finnish: FISHER.KÄÄNT
- French: FISHER.INVERSE
- German: FISHERINV
- Hungarian: INVERZ.FISHER
- Italian: INV.FISHER
- Norwegian: FISHERINV
- Polish: ROZKŁAD.FISHER.ODW
- Portuguese (Brazil): FISHERINV
- Portuguese (Portugal): FISHERINV
- Russian: ФИШЕРОБР
- Spanish: PRUEBA.FISHER.INV
- Swedish: FISHERINV
- Turkish: FISHERTERS
Try FISHERINV in the playground