Subject | Re: Standard Deviation calculation using select query ? |
---|---|
Author | Ali Gökçen |
Post date | 2005-07-14T13:29:38Z |
Hi Mario,
my previous e-mail about alternate soluion lost in internet.
here is sql friendly new formula (one pass).
select sqrt( count(x)*sum(x*x)- sum(x)*sum(x) ) / count(x)
from mytable
where mydate>=?
Regards.
Ali
my previous e-mail about alternate soluion lost in internet.
here is sql friendly new formula (one pass).
select sqrt( count(x)*sum(x*x)- sum(x)*sum(x) ) / count(x)
from mytable
where mydate>=?
Regards.
Ali