Google Sheets

ERFC.PRECISE: Google Sheets Formulae Explained

How do you use ERFC.PRECISE in Google Sheets?

The ERFC.PRECISE function in Google Sheets calculates the error function, also known as the cumulative distribution function, of a given probability. The function takes a single argument, which is the probability of interest. The function then calculates the corresponding value of the error function.

What is the syntax of ERFC.PRECISE in Google Sheets?

The syntax of ERFC.PRECISE in Google Sheets is as follows:

=ERFC.PRECISE(number)

This function calculates the error function (ERF) of a given number.

What is an example of how to use ERFC.PRECISE in Google Sheets?

ERFC.PRECISE is a function in Google Sheets that calculates the error function of a given set of data. To use the function, you first need to enter the data into a spreadsheet. Then, select the cells that contain the data, and use the function ERFC.PRECISE( in the formula bar. This will return the error function for the data in the selected cells.

When should you not use ERFC.PRECISE in Google Sheets?

There are a few occasions when you should not use ERFC.PRECISE in Google Sheets. ERFC.PRECISE is designed to calculate the error function Æ’(x) for a given set of x-values. However, it is not suitable for use in situations where you need to calculate the cumulative distribution function (CDF) or inverse cumulative distribution function (ICDF) of a given set of x-values. Additionally, ERFC.PRECISE should not be used when calculating the integral of a function over a given interval.

What are some similar formulae to ERFC.PRECISE in Google Sheets?

There are a few similar formulae to ERFC.PRECISE in Google Sheets. One is ERFC(x). This returns the complementary error function of x, which is defined as

ERFC(x) = 1 - ERF(x)

Another is ERF(x). This function returns the error function of x, which is defined as

ERF(x) = 2 ∫0 x e-t²dt

Finally, there is ERFC.PRECISE. This function is similar to ERFC, except that it is more precise and has a smaller error.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.