

Archives of the TeradataForum
Message Posted: Wed, 03 Mar 2004 @ 17:55:18 GMT
Subj:   Re: Standard Deviation formula 

From:   Victor Sokovin 
 Yes, somehow I have a poor math, and till now still could not figure out how to expand the formula as shown in "SD.JPG" to something like
what Teradata has shown in STDDEV_POP.  
No, your math must be OK. The formula for STDDEV_POP in the documentation is likely to be a typo. There are more details in the other thread I
mentioned.
 What Mansfield and Dieter said was correct. At least I am able to prove that the computation of STDDEV_POP on the data samples which
I presented, is correct.  
That's the good news; thanks for posting the results. Of course, it would be nice to have the right formula in the documentation but what is
more important is the formula which had actually been implemented in Teradata. Your results confirm once again that it is the right one.
Regards,
Victor
 