Re: Get Standard Deviation easily?

From: Peter Brenner <pbrenner_at_charlotte.infi.net>
Date: Thu, 6 May 1999 21:29:43 -0400
Message-ID: <7gtfnm$qel$1@nw001t.infi.net>

SQL*Plus has a built in function that will calculate standard deviation. This function is called STDDEV and can be used in a select statement like so:

select STDDEV(colname)
from table

There is also a function to calculate the variance called VARIANCE(column name).

HTH
Peter

oliver wrote in message <3731CA39.D91D556A_at_agyinc.com>...
>Hi,
>
>Is there any easy way for the Oracle to calculate the SD (standard
>deviation) of some value directly or call some building in function if
>there are any. Hope somebody has this experience before.
>
>Thanks
>
>Oliver
>
Received on Thu May 06 1999 - 20:29:43 CDT