Re: computing median

I may have mentioned this in a past posting: the easiest way is to bring the data from Oracle into Excel and compute the median...you can then return it to Oracle for use...

Or,
use a report generator that can compute medians ( like Crystal )

John Russell <johnrussell10_at_home.com> wrote:

>On Fri, 20 Apr 2001 18:48:13 +0200, Herwig Henseler
><hh_at_ecce-terram.de> wrote:
>
>>Hi experts,
>>
>>[Oracle 8i 8.1.7]
>>
>>How do I compute the Median of values in a table? I guess this must be a
>>FAQ but haven't found an answer so far. The median is the value in the
>>"middle" of a sorted list of values. That is, half of all values are
>>bigger and the other half is smaller than the median.
>>
>>TIA,
>>Herwig
>
>I heard once a suggestion to use the CUME_DIST function but I believe
>it needs some logic wrapped around it to give the median.
>
>John
Received on Mon Apr 23 2001 - 08:56:42 CDT