Documentation/Calc Functions/FISHER

    From The Document Foundation Wiki

    Function name:

    FISHER

    Category:

    Statistical Analysis

    Summary:

    Calculates the Fisher transformation (also known as the Fisher z-transformation) for a given number, which is assumed to be a Pearson correlation coefficient. The sampling distribution of the transformed variable follows a normal distribution.

    Syntax:

    FISHER(Number)

    Returns:

    Returns a real number, which is the Fisher transformation of the given sample correlation coefficient value.

    Arguments:

    Number is a real number in the range (-1, 1), or a reference to a cell containing that number, which is the value to be transformed.

    • If Number is non-numeric, then FISHER reports a #VALUE! error.
    • If Number is less than or equal to -1.0, or greater than or equal to 1.0, then FISHER reports an invalid argument error (Err:502).

    Additional details:

    • The formula for the FISHER function is:
    [math]\displaystyle{ \text{FISHER}(r)~=~\frac{1}{2}\ln\left(\frac{1+r}{1-r} \right) }[/math]
    where r is a correlation coefficient.
    • FISHER utilizes the same formula as the ATANH function.
    • The figure below illustrates the FISHER function:
    Fisher transformation plot.png

    Examples:

    Formula Description Returns
    =FISHER(A1) where cell A1 contains the value -0.8. Here the formula calculates the Fisher transformation of -0.8. -1.09861228866811
    =FISHER(0) Here the formula calculates the Fisher transformation of 0. 0
    =FISHER(0.8) Here the formula calculates the Fisher transformation of 0.8. 1.09861228866811

    Related LibreOffice functions:

    ATANH

    FISHERINV

    ODF standard:

    Section 6.18.26, part 2

    Related (or similar) Excel functions:

    FISHER