Table of Contents
The ERF function in Google Sheets is a useful tool for calculating the error function of a given value. This statistical function allows users to easily determine the probability of a given value falling within a certain range of values. By inputting the necessary parameters, such as the mean and standard deviation, the ERF function can accurately calculate the probability of a value being within a certain distance from the mean. This allows users to analyze and interpret data more effectively, making it a valuable tool for statistical analysis in Google Sheets.
ERF function
The ERF function returns the integral of the Gauss error function over an interval of values.
Parts of an ERF formula
ERF(lower_bound, [upper_bound])
| Part | Description | Notes |
lower_bound | If this parameter is the only parameter, the integral is taken between 0 and this value. If z2 is provided, it refers to the lower boundary for the integral. | |
upper_bound | The upper boundary of the integral. | Upper boundaries are optional. |
Sample formulas
ERF(-2.3, -0.7)
ERF(1)
Notes
If the lower or upper boundaries are non-numeric, ERF returns “#VALUE!.”
Examples
| A | B | |
| 1 | Formula | Result |
| 2 | ERF(-2.3, -0.7) | 0.3210556296 |
| 3 | ERF(1) | 0.8427007929 |
Related functions
- ERFC: The ERFC function returns the complementary Gauss error function of a value.
- NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
Cite this article
stats writer (2024). How can I use the ERF function in Google Sheets to calculate the error function of a given value?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-erf-function-in-google-sheets-to-calculate-the-error-function-of-a-given-value/
stats writer. "How can I use the ERF function in Google Sheets to calculate the error function of a given value?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-erf-function-in-google-sheets-to-calculate-the-error-function-of-a-given-value/.
stats writer. "How can I use the ERF function in Google Sheets to calculate the error function of a given value?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-erf-function-in-google-sheets-to-calculate-the-error-function-of-a-given-value/.
stats writer (2024) 'How can I use the ERF function in Google Sheets to calculate the error function of a given value?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-erf-function-in-google-sheets-to-calculate-the-error-function-of-a-given-value/.
[1] stats writer, "How can I use the ERF function in Google Sheets to calculate the error function of a given value?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the ERF function in Google Sheets to calculate the error function of a given value?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.