Как пользоваться функцией QUARTILE.EXC в Excel
| Русский | Английский |
|---|---|
| КВАРТИЛЬ.ИСКЛ | QUARTILE.EXC |
The QUARTILE.EXC function (or КВАРТИЛЬ.ИСКЛ in the Russian version of Excel) calculates a specified quartile for a given set of data, excluding extremes and interpolating between data points when necessary.
How QUARTILE.EXC Works
The syntax for the QUARTILE.EXC function in Excel is as follows:
=QUARTILE.EXC(array, quart)Parameters:
array— The array or range of cells for which the quartile is desired.quart— The quartile number (1, 2, 3, or 4) you want to determine.
Quartiles are values that divide a ranked dataset into four equal parts. The first quartile (Q1) is the value below which 25% of the data fall. The second quartile (Q2), also known as the median, is the value below which 50% of the data fall. The third quartile (Q3) is the value below which 75% of the data fall.
Examples of Using QUARTILE.EXC
Consider the dataset: 10, 15, 20, 25, 30, 35, 40, 45. Let»s find the following:
- First Quartile (25%):
| Data | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 |
Excel formula: =QUARTILE.EXC(A2:I2, 1)
Result: 18.75
- Second Quartile (50% or median):
| Data | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 |
Excel formula: =QUARTILE.EXC(A3:I3, 2)
Result: 25
- Third Quartile (75%):
| Data | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 |
Excel formula: =QUARTILE.EXC(A4:I4, 3)
Result: 36.25
In summary, the QUARTILE.EXC function is a useful tool for quickly finding quartile values in a dataset, aiding in the analysis of statistical data.
Больше информации: https://support.microsoft.com/ru-ru/office/квартиль-искл-функция-квартиль-искл-5a355b7a-840b-4a01-b0f1-f538c2864cad