Share via


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

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

Equation for the inverse Fisher transformation

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace