Documentation/Calc Functions/ERFC.PRECISE

    From The Document Foundation Wiki
    This page contains changes which are not marked for translation.

    Function name:

    ERFC.PRECISE

    Category:

    Statistical Analysis

    Summary:

    Calculates values of the complementary error function. If erf(x) is the value of the (Gauss) error function for variable x, then the complementary error function erfc(x) is defined as [math]\displaystyle{ erfc(x)~=~1\:-\:erf(x) }[/math].

    Syntax:

    ERFC.PRECISE(Lower limit)

    Returns:

    Returns a real number in the range 0 < x < 2, which is the value of the complementary error function for the specified limit.

    Arguments:

    Lower limit is a real number, or a reference to a cell containing that number, which is the lower limit of the integral that defines the complementary error function. The upper limit of the integral is automatically set to +∞.

    • If Lower limit is non-numeric, then ERFC.PRECISE reports a #VALUE! error.

    Additional details:

    • Calc's ERFC and ERFC.PRECISE functions perform similar calculations. The requirements for ERFC are specified in ODF 1.2; ERFC.PRECISE is provided for interoperability with Microsoft Excel.
    • The formula for ERFC.PRECISE is:
    [math]\displaystyle{ \text{ERFC.PRECISE}(x)~=~1\:-\:\text{ERF.PRECISE}(x)~=~\frac{2}{\sqrt{\pi}}\:\int_{x}^{\infty }e^{-t^2}dt }[/math]
    where x is the limit of the integral.
    • The following figure illustrates the ERFC.PRECISE function:
    Plot for ERFC.PRECISE function
    • The name space for ERFC.PRECISE is COM.MICROSOFT.ERFC.PRECISE.
    • For more information about the error function, visit Wikipedia's Error function page.

    Examples:

    Formula Description Returns
    =ERFC.PRECISE(A1) where cell A1 contains the value -1.1. Here the function calculates the integral between -1.1 and +∞. Note that the formula =ERFC(A1) returns the same result. 1.88020506957408
    =ERFC.PRECISE(0) Here the function calculates the integral between 0 and +∞. Note that the formula =ERFC(0) returns the same result. 1
    =ERFC.PRECISE(1.1) Here the function calculates the integral between 1.1 and +∞. Note that the formula =ERFC(1.1) returns the same result. 0.119794930425918

    Related LibreOffice functions:

    ERF

    ERFC

    ERF.PRECISE

    ODF standard:

    None

    Related (or similar) Excel functions:

    ERFC.PRECISE since v.2010.