Returns the k-th percentile of values in a range.
Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.
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.
=PERCENTILE({1,2,3,4,5}, 0.5)Resultado: 3
Returns the median value of the dataset.
Excel interpolates between the two nearest values to determine the percentile.