この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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)結果: 3
Returns the median value of the dataset.
Excel interpolates between the two nearest values to determine the percentile.