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.Doubley - 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
.jpg "Equation for the inverse Fisher transformation")