ERFC

The ERFC function in Google Sheets returns the complementary Gauss error function of a value. It is used to calculate the probability of an event occurring in standard normal distribution.

Function Syntax and Parameters

Syntax: ERFC(z)

Parameters:

• z: The value for which you want to calculate the complementary Gauss error function.

Step-by-Step Tutorial

1. Using ERFC with a value:
   • Example: =ERFC(1.5)
   • Result: Returns the complementary Gauss error function of 1.5.

Use Cases and Scenarios

1. Random Variable Analysis: Calculate the complementary error function of a given random variable.
2. Probability Analysis: Determine the probability of an event in a normal distribution.
3. Statistical Analysis: Perform calculations based on normal distribution.

Related Functions

There are no related functions for ERFC.