Statistical - FISHERINV Function

Description

The FISHERINV function returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

Syntax

FISHERINV(y)

Arguments

Argument	Description	Required/ Optional
Y	The value for which you want to perform the inverse of the transformation.	Required

Notes

The equation for the inverse of the Fisher transformation is −

$$x=\frac{e^{2y}-1}{e^{2y}+1}$$
If y is nonnumeric, FISHERINV returns the #VALUE! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm