Documentation/Calc Functions/ERFC.PRECISE

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

    TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

    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.


    Retrieved from "https://wiki.documentfoundation.org/index.php?title=Documentation/Calc_Functions/ERFC.PRECISE&oldid=717868"