# FISHER

## Content

This function returns the Fisher transformation for a specified value.

## Syntax

`FISHER(value)`

## Arguments

[Required] Provide a numeric value that is less than 1 and greater than –1 for which you want the transformation.

## Remarks

This transformation produces an approximately normal distribution. Use this function to perform hypothesis testing on the correlation coefficient.
The Fisher transformation is calculated as follows:
![](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-FISHER.png)
where x is the *value* argument.

## Examples

`FISHER(A43)`
`FISHER(R4C12)`
`FISHER(-0.65)` gives the result -0.7752987062