Excel functions / Statistics

FISHERINV function

Turns a Fisher-transformed value back into a correlation.

Syntax

=FISHERINV(y)

Arguments

When to use it

FISHERINV turns a Fisher-transformed value back into a correlation, for example the ends of a confidence interval.

Examples

  1. Back to the correlation

    ABC
    1z
    20.9729550.75

    In C2: =FISHERINV(A2) → 0.75

    Try this example

Common mistakes

FISHERINV 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 FISHERINV in the playground

Related functions