ERF Function in Google Sheets

Calculate the error function over a range using the ERF function.

ERF Function

The ERF function in Google Sheets computes the error function over a specified range. It is useful in statistics and probability.

Syntax

ERF(lower_bound, [upper_bound])
  • lower_bound: The lower limit of the integral. This is a required parameter.
  • upper_bound: (Optional) The upper limit of the integral. If omitted, it defaults to the lower_bound.

Examples

  1. Error Function from 0 to 1

Calculate the error function from 0 to 1:

=ERF(0, 1)

This will output approximately 0.8427.

  1. Error Function from 1 to 2

Calculate the error function from 1 to 2:

=ERF(1, 2)

This will output approximately 0.1547.

  1. Error Function at a Single Point

Calculate the error function from 0 to 1.5:

=ERF(1.5)

This will output approximately 0.9661.

Notes

  • The ERF function is commonly used in statistics for normal distribution probabilities.
  • If the upper_bound is less than the lower_bound, the function returns an error.
  • ERFC: Complementary error function.
  • NORMDIST: Normal distribution function.