Returns the k-th percentile of values in a range.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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)Risultato: 3
Returns the median value of the dataset.
Excel interpolates between the two nearest values to determine the percentile.