이 함수는 Google Sheets에서도 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.