# Documentation/Calc Functions/FISHERINV

Jump to navigation Jump to search

FISHERINV

## Category:

Statistical Analysis

## Summary:

Returns the inverse of the Fisher transformation for a given number and creates a function close to a normal distribution.

## Syntax:

FISHERINV(Number)

## Returns:

Returns a real number which is the inverse of Fisher transformation value Number. The output ranges from -1(exclusive) to +1(exclusive), i.e. (-1,+1).

## Arguments:

Number is a real number or a reference to the cell containing that number which is the value that is to undergo inverse transformation.

## Additional details:

• The formula for FISHERINV function is:

where x is the Number.

• The figure below illustrates the FISHERINV function:
• The function has the same formula as the TANH function.
• It is such that FISHERINV(FISHER(x)) = x.

## Examples:

Formula Description Returns
=FISHERINV(0.8) The formula calculates the inverse Fisher transformation of 0.8. 0.664036770267849
=FISHERINV(1.8) The formula calculates the inverse Fisher transformation of 1.8. 0.946806012846268

FISHERINV