FISHERINV function
FISHERINV reverses the Fisher transformation, converting a value back into a correlation coefficient. The result is always between -1 and 1, and it equals the hyperbolic tangent, TANH.
Example
Read it as a sentence: apply the inverse Fisher transformation to D1, which is empty and counted as 0.
Excel shows 0
D
1
Data
Syntax
FISHERINV(y)
-
y(required) - Fisher-transformed value.
Returns: The inverse Fisher transformation of y.
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 |
|---|---|---|
=FISHERINV(1) | 0.761594156 | Working example |
=FISHERINV("1") | 0.761594156 | Text-number in first arg |
=FISHERINV({1,1}) | 0.761594156 | Array in first arg (lifts, spills) |
=FISHERINV(50) | 1 | Large y |
=FISHERINV(-1) | -0.761594156 | Negative |
=FISHERINV(Data!D1) | 0 | Blank cell as first arg |
=FISHERINV("abc") | #VALUE! | Non-numeric text in first arg |
=FISHERINV(NA()) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Equals the hyperbolic tangent, TANH.
- Always returns a number between -1 and 1.
Where it works
- Excel
- FISHERINV 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 .