SheetFX
≡
<< Go back to all functions

ERF

The ERF function in Google Sheets is a powerful tool to return the integral of the Gauss error function over an interval of values. Whether you're working with engineering calculations or statistical analysis, the ERF function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: ERF(lower_bound, [upper_bound])

Parameters:

  • lower_bound: The lower bound of the integral.
  • upper_bound: [Optional] The upper bound of the integral.

Step-by-Step Tutorial

  1. Using ERF with a single lower bound:

    • Example: =ERF(2)
    • Result: Returns the integral of the Gauss error function from negative infinity to 2.

  2. Using ERF with both lower and upper bounds:

    • Example: =ERF(1, 3)
    • Result: Returns the integral of the Gauss error function from 1 to 3.

Use Cases and Scenarios

  1. Engineering Calculations: Calculate the probability of a voltage exceeding a certain threshold.
  2. Statistical Analysis: Determine the probability distribution of a random variable.
  3. Signal Processing: Evaluate the error rate in a communication system.

Related Functions

  • ERFC: Returns the complementary Gauss error function.

Related Articles