Как пользоваться функцией 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

Другие функции
Возвращает обратное значение для F-распределения вероятности
Возвращает распределение Вейбулла
Вычисляет дисперсию для генеральной совокупности, включая числа, текст и логические значения