ERFC

The ERFC function in Google Sheets returns the complementary Gauss error function of a value. It's the counterpart to ERF, calculated as 1 - ERF(z), and is widely used in probability and statistics involving the normal distribution. Dive into our comprehensive guide to master its application.

Parameters

• z: The lower bound 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: 0.0338949

2. Using ERFC at zero:

   • Example: =ERFC(0)
   • Result: 1

Use Cases and Scenarios

1. Random Variable Analysis: Calculate the complementary error function of a given random variable.
2. Probability Analysis: Determine tail probabilities for events in a normal distribution.
3. Statistical Analysis: Perform calculations based on normal distribution models in engineering and physics.

Related Functions

• ERF: Returns the integral of the Gauss error function over an interval of values.
• ERF.PRECISE: Returns the integral of the Gauss error function evaluated between 0 and a supplied limit.
• ERFC.PRECISE: Returns the complementary Gauss error function of a value.

Related Articles

No related articles available for the ERFC function.