To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93422 Issue #|93422 Summary|MODE - calculation incorrect Component|Spreadsheet Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|kiwibiochemist
------- Additional comments from [EMAIL PROTECTED] Wed Sep 3 11:36:27 +0000 2008 ------- The function MODE() should return the most frequent item in the data. Currently, if the data contains two items that occur with equal frequency only one is identified. This gives a false impression of the data. At the very least the MODE() function should identify the existence of two items with equal frequency so that the user can decide whether the data is bimodal or otherwise. As it is at present every data set has to be checked some other way. I'll attach a file as an example. For comparison the data is handled correctly at http://www.easycalculation.com/statistics/mean-median-mode.php which shows the two most frequent items. --------------------------------------------------------------------- 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]
