To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69712
Issue #|69712
Summary|QUARTILE function works incorrectly in some cases
Component|Spreadsheet
Version|OOo 2.0.3
Platform|PC
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|pmike
------- Additional comments from [EMAIL PROTECTED] Wed Sep 20 22:17:34 -0700
2006 -------
It seems that QUARTILE() function always calculate its result as simple average
of two adjacent values. This is not correct.
The correct formulaes are (where N is number of elements):
(N+1)/4 for QUARTILE(,1);
(N+1)/2 for QUARTILE(,2);
3(N+1)/4 for QUARTILE(,3).
generally: X(N+1)/4 for QUARTILE(,X), where X={1,2,3}
Note: Excel also works incorrectly, but I suppose this is the case we could
break 'compatibility' with errorneous behavior of Excel.
Statistical applications like SPSS, Minitab and PHStat for Excel works
correctly.
Some info about Excel faults:
http://www.daheiser.info/excel/notes/notew.pdf
http://www.cs.uiowa.edu/~jcryer/JSMTalk2001.pdf
or simply google for "Excel wrong QUARTILE"
The sample file shows errorneous calculations. Red values are wrong, green
values are OK, and blue values are simple averages.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
