# Talk:Documentation/Calc Functions/QUARTILE

From The Document Foundation Wiki

## SF comments

- (1) Summary. Maybe include something obvious to describe what quartiles are? Perhaps add – “Quartiles describe the division of a data set into four intervals based on the values of the data. The lowest 25% of the values are smaller than the first or lower quartile (equivalent to the 25th percentile). The lowest 50% of the values are smaller than the second quartile and this is also known as the median (equivalent to the 50th percentile). The lowest 75% of the values are smaller than the third or upper quartile (equivalent to the 75th percentile).”.
- (2) Returns. Suggest the following alternative – “Returns a real number which is the requested quartile of the specified data set.”.
- (3) Arguments, bullet. Insert “or” before “equal”.
- (4) Examples, general. The Descriptions in this table appear unnecessarily verbose. For example, the first could simply read “Calculates the maximum value of the data in cells A1:A5.”. Similarly, the second could read “Calculates the third or upper quartile value of the data in cells A1:A5.”. And so on…
- (5) Examples, final example. Did you intend the formula to specify the cell range as A1:A6?
- (6) Related LibreOffice functions. Is there a particular reason why PERCENTILE.INC and PERCENTILE.EXC have been excluded?

--Stevefanning (talk) 2020-11-03T20:43:38 (UTC)