Excel Statistics: ERFC Function and How to Use it

by | Dec 28, 2023

erfc

In the expansive realm of Excel, the ERFC function emerges as a pivotal tool in Excel statistical analysis. This engineering excel statistics formula meticulously calculates and delivers the complementary error function, providing insights into the probability distribution of a value within a specified range. A subset of the broader error functions, ERFC is instrumental in assessing the likelihood of a value conforming to a normal distribution. Colloquially known as Gauss error functions, these mathematical tools form the backbone of statistical analyses in Excel.

In this comprehensive guide, we will unravel the intricacies of the ERFC function, offering step-by-step insights into its application. From understanding its statistical significance to practical tips and error handling methods, this guide is your key to mastering Excel statistics. Join us on a journey where we explore the dynamics of ERFC, providing you with the knowledge and expertise to elevate your statistical analyses using this powerful Excel formula.

Supported versions

  • All Excel versions (The function was improved in Excel 2010 to add support for negative arguments)

ERFC Function Syntax

ERFC(x)

Arguments

x The lower bound of the integral.

Example

The ERFC function needs only a single argument as an input, x. The x value argument represents the lower bound for integrating the complementary error function. The function accepts negative numerical values in Excel versions 2010 and later. Below are some examples of its use.

=ERFC(1) integrates between 1 and ∞

erfc

Download Workbook

Tips for Excel Statistical Analysis

  • Other related Excel statistics functions:
    • ERFC.PRECISE function works the same as the ERFC function. ERFC.PRECISE was added for the sake of consistency between function names.
    • ERF function, can find the integration between a lower and upper limit.
    • ERF.PRECISE function returns the error function between 0 and the entered argument.
  • For further readings, click here.

Issues

  • If x is a non-numeric value, the function returns the #VALUE! error value.
  • The function returns the #NUM! error if one or both of the arguments are negative in Excel 2007 or earlier versions of Excel.