Hnnnnnk! No cookie, but thank you for playing!

I don't have a method built, but felt compelled to say your method gives the Mean, not the Median.

Mean = Average, Median != Average.

From Websters Collegiate Dictionary

"The middle number in a given sequence of numbers...: 4 is the median of 1,3,4,8,9"

Note the mean (average) of the series = 5, not 4.

The method would seem to have to include ordering the numbers, then traversing the listing from both ends an equal amount until there is either one (an odd number of numbers) or two numbers (an even number of numbers in the list), then either returning the lone number, or averaging the two remaining numbers to get a final result.


Walt Hunnel
Systems Administrator
Lawrence Memorial Hospital
325 Maine
Lawrence, KS 66044
785 840-2957
Pager # 830-5329

>>> "Sinkiewicz, Gerald P" <[Email Address Removed] 10/31/01 07:46AM >>>

Median(list)= (max(list)+min(list))/2.




-----Original Message-----
From: Michael McMullen [mailto:[Email Address Removed] Wednesday, October 31, 2001 8:41 AM
To: LazyDBA.com Discussion
Subject: finding the median


Hello

Anybody ever come up with a way to get the median from a list of values.

Thanks

Mike
[Email Address Removed]Oracle LazyDBA home page