Advanced Excel Statistical - FISHER Function

Description

The FISHER function returns the Fisher transformation at x. This transformation produces a Function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.

Syntax

FISHER(x)

Arguments

Argument	Description	Required/ Optional
X	A numeric value for which you want the transformation.	Required

Notes

The equation for the Fisher transformation is −

$${z}'=\frac{1}{2} ln\left ( \frac{1+x}{1-x} \right )$$
If x is nonnumeric, FISHER returns the #VALUE! error value.
If x ≤ -1 or if x ≥ 1, FISHER returns the #NUM! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm