This documentation is archived and is not being maintained.

WorksheetFunction.FisherInv Method (Excel)

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.

expression .FisherInv(Arg1)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

y - the value for which you want to perform the inverse of the transformation.

Return Value

Double

  • If y is nonnumeric, FISHERINV returns the #VALUE! error value.

  • The equation for the inverse of the Fisher transformation is: Ff838597.awffshri_ZA06051142(en-us,office.14).gif

Show: