Description: I think, there is an error in the function QUARTILE of the CALC-section For example: Dataset: 5 6 9 12 17 20 22 22 19 14 9 6 QUARTILE (..;0) is correct 5 (= MIN), QUARTILE (..;1) delivers 8.25 (???) (should be 7.5), QUARTILE (..,2) is correct 13 (= MEDIAN), QUARTILE (..;3) delivers 19.25 ??? (should be 19.5), QUARTILE (..,4) is correct 22 (= MAX). LO Version: 6.4.0.3 (x64) Build-ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8 Actual Results: As described above Expected Results: As described above Reproducible: Always User Profile Reset: No Additional Info: As described above
https://www.icalcu.com/stat/fivenum.html [Tukey's hinge method] Minimum=5, Q1=7.5, Median=13, Q3=19.5, Maximum=22 [TI-83 & TI-84 & TI-89 method] Minimum=5, Q1=7.5, Median=13, Q3=19.5, Maximum=22 [Percentile method] Minimum=5, Q1=8.25, Median=13, Q3=19.25, Maximum=22
At least, Excel 365 installed locally returns same value as calc. Proposing NOTABUG
Calc implements the percentile method, as common for all spreadsheet software. See the definition given in https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#QUARTILE and for a possible algorithm https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#PERCENTILE