WorksheetFunction.FisherInv Method

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function FisherInv ( _
    Arg1 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim returnValue As Double

returnValue = instance.FisherInv(Arg1)

double FisherInv(
    double Arg1
)

Parameters

• Arg1
  Type: System.Double

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

Return Value

Type: System.Double

Remarks

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

The equation for the inverse of the Fisher transformation is:

Figure 1: Equation for the inverse Fisher transformation

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace