Formualizer Docs
ReferenceFunctionsStatistics Functions

FISHER

Returns the Fisher z-transformation of a correlation-like value `x`.

Summary

FISHER maps (-1, 1) into (-inf, +inf) and is commonly used in correlation inference.

Remarks

  • Input must satisfy -1 < x < 1.
  • Returns #NUM! when x <= -1 or x >= 1.
  • The transformation is 0.5 * ln((1 + x) / (1 - x)).
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Fisher transform at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0
Fisher transform at x=0.5
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5493061443340549

Runtime metadata

Category

Statistics

Signature

FISHER(arg1: Number (Range))

Arity

min 1, max 1

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PURENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

F.TEST

F.TEST: Returns the two-tailed p-value from an F-test comparing sample variances.

FISHERINV

FISHERINV: Returns the inverse Fisher transformation of `y`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata