Talk:Documentation/Calc Functions/QUARTILE
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)
Ronnie
all points addressed. About point 6, there doesn't seem any need for them PERCENTILE will link them.
Laura comments
Suggestion: In Additional Details in the pin, add that QUARTILE is also inclusive like QUARTILE.INC?
--Stevefanning (talk) 2021-10-26T13:01:08 (UTC)
Updated pin as suggested.