Returns the quartile of a data set based on percentile values from 0 to 1.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
QUARTILE(array, quart)The QUARTILE function is used to calculate the quartile of a data set, which is useful for analyzing the distribution of data. It identifies the value at a specific quartile point, such as the minimum, median, or maximum, within the provided array.
=QUARTILE({1,2,3,4,5,6,7,8,9,10}, 1)Результат: 3.25
Returns the first quartile (25th percentile) of the numbers 1 through 10.
QUARTILE is a compatibility function that is equivalent to QUARTILE.INC, which includes 0 and 1 in the percentile calculation.