Manuals/calci/QUARTILE
Jump to navigation
Jump to search
QUARTILE(arr,q)
Where arr is the array and q is the value to be return.
If q=0,QUARTILE returns minimum value,
q=1,QUARTILE returns first quartile,i.e.25th percentile,
q=2,QUARTILE returns median quartile,i.e.50th percentile,
q=3,QUARTILE returns third quartile,i.e.75th percentile,
q=4,QUARTILE returns maximum value
It calculates the quartile of a data set.
- If array is empty, QUARTILE displays zero.
- QUARTILE displays error when q is less than 0 or is grater than 4.
QUARTILE
i.e. =QUARTILE (C1R1:C1R8, 1) is 7.5
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 5 | 7.5 | ||||
| Row2 | 6 | |||||
| Row3 | 8 | |||||
| Row4 | 10 | |||||
| Row6 | 12 | |||||
| Row7 | 14 | |||||
| Row8 | 15 | |||||
| Row9 | 16 | 0.5253 |
