PERCENTILE : General Usage
1
data
sorted_data
2
72
17
3
57
32
4
66
57
5
92
66
6
32
72
7
17
92
8
146
146
9
10
11
alpha
Result
Formula
12
0.5
66
=PERCENTILE(A2:A8, 0.5)
13
0.2
32
=PERCENTILE(A3:A9, A13)
14
1
146
=PERCENTILE(A4:A10, A14)
15