SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / FISHERINV
In This Topic
    FISHERINV
    In This Topic

    This function returns the inverse of the Fisher transformation for a specified value.

    Syntax

    FISHERINV(value)

    Arguments

    The argument is the specified numeric value.

    Remarks

    Use this transformation when analyzing correlations between ranges or arrays of data. This function calculates the inverse of the Fisher transformation, so if y = FISHER(x), then FISHERINV(y) = x.

    The inverse Fisher transformation is calculated as follows:

    FISHERINV Equation

    where y is the value argument.

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    FISHERINV(A43)

    FISHERINV(R4C12)

    FISHERINV(0.56) gives the result 0.5079774329

    See Also