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

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

  1. Transform a correlation of 0.75

    ABC
    1r
    20.750.9730

    In C2: =FISHER(A2) → 0.9730

    Try this example

Common mistakes

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.

Translate a whole formula

Try FISHER in the playground

Related functions