To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69712
------- Additional comments from [EMAIL PROTECTED] Thu Sep 21 01:53:37 -0700 2006 ------- Hi Frank, http://www.daheiser.info/excel/notes/noteh.pdf Really, there is no standard for quartiles calculation, therefore no 'strong' reasons to claim incorrectness of Excel calculations. However, QUARTILE() is a statistical function and sticking with one (and probably not most popular due to differences with statistic-oriented software) is not good idea. So, my proporsal would be: add third optional parameter to QUARTILE() function, from 1 to 14, to choose method of quartile calculation. Default will be Excel-compatible method. This gives Calc good advantage in compare to Excel, and makes Calc more useful for statistical analysis. Here is some info about different methods of quartiles calculation in use: http://mathworld.wolfram.com/Quartile.html If you'd like to close this issue as WONTFIX (with short explanation), I can file another feature request issue. WBR, Mike --------------------------------------------------------------------- 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]
