SheetFX
≡
<< Go back to all functions

ERFC.PRECISE

The ERFC.PRECISE function in Google Sheets is used to find the complementary Gauss error function integrated between a given value, z, and infinity. This function is typically used in statistical calculations.

Function Syntax and Parameters

Syntax: ERFC.PRECISE(z)

Parameter:

  • z: The value at which to evaluate the complementary Gauss error function.

Step-by-Step Tutorial

Here is an example of using the ERFC.PRECISE function:

  1. Using ERFC.PRECISE with a specific value:
    • Example: =ERFC.PRECISE(2)
    • Result: 0.004677734981047265

Use Cases and Scenarios

  1. Statistical Analysis: Used in probability calculations and statistical distributions.

Related Functions

  • ERF: Returns the Gauss error function integrated between zero and a given value.

Related Articles