# Documentation/Calc Functions/FISHERINV

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

FISHERINV