Google Sheets-funktion

PERCENTILE

Returns the k-th percentile of values in a range.

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

PERCENTILE(array, k)

The PERCENTILE function calculates the value below which a given percentage of data points fall. It is useful for establishing a threshold or identifying relative standing within a dataset.

Argument

arrayobligatorisktThe array or range of data that defines relative standing.
kobligatorisktThe percentile value in the range 0 to 1, inclusive.

Exempel

=PERCENTILE({1,2,3,4,5}, 0.5)

Resultat: 3

Returns the median value of the dataset.

Vanliga frågor

What happens if k is not a multiple of 1/(n-1)?

Excel interpolates between the two nearest values to determine the percentile.

Relaterade funktioner

MEDIAN QUARTILE