Google Sheets-funktion

QUARTILE

Returns the quartile of a data set based on percentile values from 0 to 1.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

arrayobligatorisktThe range of cells or array of numerical values for which you want the quartile value.
quartobligatorisktThe specific quartile to return, represented by an integer from 0 to 4.

Exempel

=QUARTILE({1,2,3,4,5,6,7,8,9,10}, 1)

Resultat: 3.25

Returns the first quartile (25th percentile) of the numbers 1 through 10.

Vanliga frågor

What is the difference between QUARTILE and QUARTILE.INC?

QUARTILE is a compatibility function that is equivalent to QUARTILE.INC, which includes 0 and 1 in the percentile calculation.

Relaterade funktioner

QUARTILE.INC MEDIAN PERCENTILE