[Libreoffice-bugs] [Bug 130910] New: Error in the QUARTILE function of CALC ?
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Feb 24 19:25:27 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=130910
Bug ID: 130910
Summary: Error in the QUARTILE function of CALC ?
Product: LibreOffice
Version: 6.4.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: ruediger.bamberg at gmx.de
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
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200224/0dd5a842/attachment.htm>
More information about the Libreoffice-bugs
mailing list