Documentation/Calc Functions/ERFC.PRECISE

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

ERFC.PRECISE

Category:

Statistical Analysis

Summary:

Returns complementary values of the Gaussian error function(integral), also called as error function, between a lower limit and infinity. This is a complementary error function.

Syntax:

ERFC.PRECISE(LowerLimit)

Returns:

Returns a real number which is the complementary error function value for LowerLimit and it ranges from 0 to 2, i.e. (0,2).

Arguments:

LowerLimit is the lower limit of the integral. The calculation takes place between this limit and ∞. Here limit can be any real number or a reference to the cell containing that number.

  • If the LowerLimit is not a real number or the referenced cell doesn't contain a real number then the function returns a value(#VALUE!) error.

Additional details:

The formula for ERFC.PRECISE is:

Erfc eq2.png

where L is the LowerLimit.

The figure below illustrates the function ERFC.PRECISE:

ERFC.PRECISE function
  • ERFC.PRECISE(L) = 1 - ERF.PRECISE(L)
  • For more details on ERFC.PRECISE, visit Wikipedia.

Examples:

Formula Description Returns
=ERFC.PRECISE(1) The function calculates the complementary error function value for LowerLimit as 1. 0.157299207050285
=ERFC.PRECISE(-1) The function calculates the complementary error function value for LowerLimit as -1. 1.84270079294972

Related LibreOffice functions:

ERFC.PRECISE

ERFC

ERF

ODF standard:

None

Equivalent Excel functions:

ERFC.PRECISE