ERFC.PRECISE

Formulas / ERFC.PRECISE
Return the complementary ERF function between x and infinity.
=ERFC.PRECISE(x)
  • x - required argument that is the lower bound for integrating ERFC.PRECISE

Examples

  • =ERFC.PRECISE(1)

    The ERFC.PRECISE function calculates the complementary error function of a given number. The error function is used in probability and statistics to calculate the area under the normal distribution curve. For example, this formula returns the complementary error function of 1.

    • The ERFC.PRECISE function is useful for calculating probabilities for values of a standard normal distribution. For example, if you're trying to calculate the probability that a value is greater than 1 in a standard normal distribution, you can use the ERFC.PRECISE function to calculate the complementary error function of 1, which is the probability of the value being less than or equal to 1.

    The ERFC.PRECISE function can also be used to calculate the inverse of the complementary error function. This is useful when you need to calculate the value of a normal distribution given a certain probability. For example, you can use the ERFC.PRECISE function to calculate the inverse of the complementary error function for a probability of 0.95, which would be the value for which there is a 95% chance of being less than or equal to that value.

    The ERFC.PRECISE function can also be used to calculate the probability of a given value in a normal distribution. For example, you can use the ERFC.PRECISE function to calculate the probability of a value being greater than or equal to 1, by calculating the complementary error function of 1 and subtracting it from 1. This would give you the probability of the value being greater than or equal to 1.


Summary

The ERFC.PRECISE function calculates the complementary Error Function (ERF) integrated between the x argument (the lower bound) and infinity. It requires one x argument in order to do this.

  • The ERFC.PRECISE function is a formula that takes one argument, X, which is required.
  • It integrates between x and infinity using the ERF function and its complementary ERF function is ERFC.PRECISE.

Frequently Asked Questions

What is the ERFC.PRECISE function?
The ERFC.PRECISE function is a mathematical function that returns the complementary error function between x and ∞. The complementary error function is a special mathematical function that can be used in various calculations.
What is the argument for the ERFC.PRECISE function?
The argument for the ERFC.PRECISE function is X. X is the lower bound for integrating ERFC.PRECISE.
Is the X argument required?
Yes, the X argument is required.
What is the purpose of the X argument?
The X argument is the lower bound for integrating ERFC.PRECISE.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV