FISHERINV function

Applies To
SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint Foundation 2010 SharePoint Server 2010 Windows SharePoint Services 3.0

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)

Y  is the value for which you want to perform the inverse of the transformation.

Remarks

  • If y is nonnumeric, FISHERINV returns the #VALUE! error value.
  • The equation for the inverse of the Fisher transformation is:
    Equation

Example

Formula Description (Result)
=FISHERINV(0.972955) Inverse of the Fisher transformation at 0.972955 (0.75)