Jump to content

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
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.