Excel functions / Statistics
FISHER function
The Fisher transformation of a correlation, which makes it close to normally distributed so that it can be tested.
Syntax
=FISHER(x)
Arguments
x: A correlation, between -1 and 1.
When to use it
FISHER transforms a correlation into a value that is close to normally distributed, so that confidence intervals for a correlation can be worked out. FISHERINV turns it back.
Examples
Transform a correlation of 0.75
A B C 1 r 2 0.75 0.9730 In C2:
=FISHER(A2)→ 0.9730
Common mistakes
- At 1 or -1. FISHER of 1 or -1 is #NUM!.
FISHER 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: FISHER
- Danish: FISHER
- Dutch: FISHER
- Finnish: FISHER
- French: FISHER
- German: FISHER
- Hungarian: FISHER
- Italian: FISHER
- Norwegian: FISHER
- Polish: ROZKŁAD.FISHER
- Portuguese (Brazil): FISHER
- Portuguese (Portugal): FISHER
- Russian: ФИШЕР
- Spanish: FISHER
- Swedish: FISHER
- Turkish: FISHER