Table of Contents
The QUARTILE.EXC function in Google Sheets is a mathematical tool that allows users to calculate the quartile value of a data set, excluding the median. This function can be used by typing “=QUARTILE.EXC()” into a cell and then specifying the range of data to be analyzed. By using this function, users can quickly and accurately determine the quartile values of a data set, which can be useful for analyzing and comparing data. Additionally, this function can be used in conjunction with other statistical functions to gain further insights into the distribution of the data. Overall, the QUARTILE.EXC function provides a convenient and efficient way to analyze quartile values in Google Sheets.
QUARTILE.EXC function
The QUARTILE.EXC function returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.
Parts of a QUARTILE.EXC function
QUARTILE.EXC(data, quartile_number)
| Part | Description |
data | The array or range containing the dataset to consider. |
quartile_number | This is which quartile value to return
|
Sample formulas
QUARTILE.EXC(A2:A100, 3)
QUARTILE.EXC(A2:A100, B2)
Notes
- If the
quartile_numberis not an integer, the number is truncated. - The
quartile_numbermust be between 0 and 4, exclusive. - Different from
QUARTILE.INC,QUARTILE.EXCcalculates quartile based on a quartile range exclusive of 0th and 4th quartile.
Examples
| A | |
| 1 | data |
| 2 | 6 |
| 3 | 7 |
| 4 | 15 |
| 5 | 36 |
| 6 | 39 |
| 7 | 40 |
| 8 | 41 |
| 9 | 42 |
| 10 | 43 |
| 11 | 47 |
| 12 | 49 |
| A | B | C | |
| 1 | Quartile | Result | Formula |
| 2 | 1 | 15 | =QUARTILE.EXC(A2:A12, 1) |
| 3 | 2 | 40 | =QUARTILE.EXC(A2:A12, 2) |
| 4 | 3 | 43 | =QUARTILE.EXC(A2:A12, 3) |
Related functions
- PERCENTILE: Returns the value at a given percentile of a dataset.
- PERCENTILE.EXC: The PERCENTILE.EXC function returns the value at a given percentile of a dataset, exclusive of 0 and 1.
- MEDIAN: Returns the median value in a numeric dataset.
- QUARTILE: Returns a value nearest to a specified quartile of a dataset.
Cite this article
stats writer (2024). How can I use the QUARTILE.EXC function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-quartile-exc-function-in-google-sheets/
stats writer. "How can I use the QUARTILE.EXC function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-quartile-exc-function-in-google-sheets/.
stats writer. "How can I use the QUARTILE.EXC function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-quartile-exc-function-in-google-sheets/.
stats writer (2024) 'How can I use the QUARTILE.EXC function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-quartile-exc-function-in-google-sheets/.
[1] stats writer, "How can I use the QUARTILE.EXC function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the QUARTILE.EXC function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.