Documentation/Calc Functions/FISHER
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
FISHER
Category:
Statistical Analysis
Summary:
Calculates the Fisher transformation (also known as the Fisher z-transformation) for a given number, which is assumed to be a Pearson correlation coefficient. The sampling distribution of the transformed variable follows a normal distribution.
Syntax:
FISHER(Number)
Returns:
Returns a real number, which is the Fisher transformation of the given sample correlation coefficient value.
Arguments:
Number is a real number in the range (-1, 1), or a reference to a cell containing that number, which is the value to be transformed.
- If Number is non-numeric, then FISHER reports a #VALUE! error.
- If Number is less than or equal to -1.0, or greater than or equal to 1.0, then FISHER reports an invalid argument error (Err:502).
Additional details:
- The formula for the FISHER function is:
- [math]\displaystyle{ \text{FISHER}(r)~=~\frac{1}{2}\ln\left(\frac{1+r}{1-r} \right) }[/math]
- where r is a correlation coefficient.
- FISHER utilizes the same formula as the ATANH function.
- The figure below illustrates the FISHER function:
- For more information about the Fisher transformation, visit Wikipedia's Fisher transformation page.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =FISHER(A1) where cell A1 contains the value -0.8. | Here the formula calculates the Fisher transformation of -0.8. | -1.09861228866811 |
| =FISHER(0) | Here the formula calculates the Fisher transformation of 0. | 0 |
| =FISHER(0.8) | Here the formula calculates the Fisher transformation of 0.8. | 1.09861228866811 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
FISHER