The ERFC.PRECISE function in Excel is a statistical tool that computes the complementary error function, which is essential in various fields such as engineering and probability. This function specifically evaluates the area under the Gaussian curve from a defined point to infinity. Unlike its counterpart, ERFC, this function guarantees precise results, making it invaluable for calculations requiring high accuracy.

Syntax

ERFC.PRECISE(x)

• x: The numeric value at which the complementary error function will be evaluated.

Example #1

=ERFC.PRECISE(0)

This function evaluates the complementary error function starting from 0 to infinity. The result is approximately 1.00000, indicating the total area under the curve to infinity.

Example #2

=ERFC.PRECISE(1)

In this case, the function calculates the complementary error function from 1 to infinity. The result is approximately 0.15730, which represents the probability that a value falls above 1 in a standard normal distribution.

Example #3

=ERFC.PRECISE(-1)

This function call computes the complementary error function from -1 to infinity. The output is roughly 1.84270, indicating a higher likelihood for values to exceed -1 in the standard normal distribution.

Error handling

• NUM!: This error appears if the argument provided is not a number or if it is a non-finite value like infinity.
• VALUE!: Indicates that the input to the function is not a valid numeric type.

Conclusion

The ERFC.PRECISE function is a robust and precise tool for statistical computations involving the complementary error function. Its accurate outputs are crucial for professionals needing to analyze probabilities and areas under the Gaussian curve. Mastering this function can enhance your analytical capabilities in Excel significantly.