# Documentation/Calc Functions/FISHER

Jump to navigation
Jump to search

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

## Function name:

FISHER

## Category:

Statistical Analysis

## Summary:

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

## Syntax:

FISHER(**Number**)

## Returns:

Returns a real number which is the Fisher transformation for a given sample correlation coefficient **Number**.

## Arguments:

**Number** is a real number between 0(exclusive) and 1(exclusive) or a reference to the cell containing that umber which is the value to be transformed.

- If
**Number**is greater than or equal to 1 or less than or equal to 0, then the function returns an error value.

## Additional details:

- The formula for the FISHER function is:

where n is the **Number**.

- The figure below illustrates the FISHER function:

- The function has the same formula as the ATANH function.

## Examples:

Formula | Description | Returns |
---|---|---|

=FISHER(0.8) | The formula calculates the Fisher transformation of 0.8. | 1.09861228866811 |

=FISHER(1.8) | The function returns an error value whenever Number is greater than or equal to 1. |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

FISHER