Re: Statistics Library

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 27 Jul 2001 10:43:30 +0100
Message-ID: <996226824.28004.0.nnrp-12.9e984b29@news.demon.co.uk>

Look at Oracle 8.1.6+ for the 'analytic functions' - these will cover quartiles, and various of the other statistical requirements.

Median is not on the list, though if you search the archives on google for 'median' you will find at least two threads which provided a solution based on the analytic functions.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Christian Eller wrote in message <9jrbs5$guj$1_at_fstgss02.tu-graz.ac.at>...


>Dear User,

>

>Can anybody help me with following problem?

>

>I need to compute statistical values of number series, like median and

>quartiles. The problem is that I need to do it in PL/SQL. Does anyone

>know of statistics libraries implemented in PL/SQL that provide functions

>like

>

>median (num_tab in NumTabTyp) return number

>

>and so on...

>

>Thanks for your help ... Christian

>

>

Received on Fri Jul 27 2001 - 04:43:30 CDT