| Subject | Re: [firebird-support] Re: Standard Deviation calculation using select query ? |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-07-13T15:44:51Z |
Ali Gökçen wrote:
Ann
>or
> if i remember correctly, STDDEV is:
>
> if(count(x)>1)
> sqrt ( sum((x-avg(x))*(x-avg(x))) / (count(x)-1) )
>
> if(count(x)>1)Regards,
> sqrt ( sum((x-avg(x))*(x-avg(x))) / (count(x)) )
Ann