Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 19:22:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

I'm looking to use the STDDEV_POP aggregate functions, to get the standard deviation of my population but I'm not shure of the documentation. The documentation say :

The equation for computing STDDEV_POP is as follows:

STDDEV_POP = SQRT( COUNT(x) SUM(x**2) - (SUM(x)**2 / COUNT(x)**2))

I think the documentation should say :

STDDEV_POP = SQRT(COUNT(x) SUM(x**2) - (SUM(x)**2) / COUNT(x)**2)

Does any math people can confirm what I'm thinking.

Regard,

Rudel Simard
R�gie de l'assurance-maladie du Qu�bec
Administration des donn�es

	<Prev	Next>		<<First	<Prev	Next>	Last>>