ReferenceFunctionsStatistics Functions
FISHERINV
FISHERINV: Returns the inverse Fisher transformation of `y`.
Summary
FISHERINV maps Fisher z-values back to the open interval (-1, 1).
Remarks
- The inverse form is
(e^(2y) - 1) / (e^(2y) + 1). - Output is always strictly between
-1and1for finite inputs. - This function is useful for converting transformed correlation estimates back to r-space.
- Invalid numeric coercions propagate as spreadsheet errors.
Examples
Inverse Fisher at zero
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Round-trip with FISHER(0.5)
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5
Related functions
Runtime metadata
Category
Statistics
Signature
FISHERINV(arg1: Number (Range))Arity
min 1, max 1
Arguments
arg1Number · Range · coercion NumberLenientText
Caps
PURENUMERIC_ONLY
Source