Probably should have been more specific: - the numbers are integers only - there are usually no more than 10 or 20 discrete numeric values
My algorithm determines how many discrete values there are, dimensions a 2-dimensional array, one column with the numeral and the other with the count. The array is then sorted on the count value and the most counts is the modal (if more than one has the same count, then it is multi-modal). This just seems especially in-elegant for 72 columns of numbers with perhaps 20 different groups on those columns. Tom At 06:20 AM 5/13/2008, you wrote: >I need to find the modal value of up to 72 columns of numbers. The numbers >are also grouped, so the modal values need to be found for each column for >each grouping ... and, of course, the modal value can be bi-modal or >tri-modal, etc. > >The algorithm I've been using works fine for one set of numbers but seems >awfully cumbersome for multiple columns. > >thanks, >Tom _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
