FISHER function
FISHER returns the Fisher transformation of a value, stretching a correlation coefficient onto a roughly normal scale. It is used for testing or building intervals around a correlation.
Example
Read it as a sentence: apply the Fisher transformation to D1, which is empty and counted as 0.
Excel shows 0
D
1
Data
Syntax
FISHER(x)
-
x(required) - Number strictly between -1 and 1.
Returns: The Fisher transformation of x.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FISHER(0.75) | 0.972955075 | Working example |
=FISHER("0.75") | 0.972955075 | Text-number in first arg |
=FISHER({0.75,0.75}) | 0.972955075 | Array in first arg (lifts, spills) |
=FISHER(0) | 0 | X 0 |
=FISHER(Data!D1) | 0 | Blank cell as first arg |
=FISHER("abc") | #VALUE! | Non-numeric text in first arg |
=FISHER(NA()) | #N/A | Error in first arg |
=FISHER(1) | #NUM! | X = 1 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- x of exactly 1 or -1 returns #NUM!.
- Equals the inverse hyperbolic tangent, ATANH.
Where it works
- Excel
- FISHER is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .