Archives of the TeradataForum
Message Posted: Fri, 27 Feb 2004 @ 11:59:10 GMT
The STDDEV_POP equation is equivalent to your SD equation. The key difference between the two being the denominator of N in the pop version versus (N-1) in the samp version.
This can be demonstarated by expanding the term in the sum, but I leave that to you to do if you want.
This method is however subject some rounding error, but allows the computation in one pass through the data. This is most noticeable if the values are different by orders of magnitude.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|