1 | data | ||||
---|---|---|---|---|---|
2 | 3 | ||||
3 | 7 | ||||
4 | 9 | ||||
5 | 10 | ||||
6 | |||||
7 | |||||
8 | Result | Formula | type | Description | |
9 | 3 | =QUARTILE(A2:A5, 0) | 0 | The smallest value | |
10 | 6 | =QUARTILE(A2:A5, 1) | 1 | The first quartile (25 percentile) | |
11 | 8 | =QUARTILE(A2:A5, 2) | 2 | The second quartile (50 percentile) | |
12 | 9.25 | =QUARTILE(A2:A5, 3) | 3 | The third quartile (75 percentile) | |
13 | 10 | =QUARTILE(A2:A5, 4) | 4 | The largest value | |
14 |