Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Mar 2004 @ 17:55:18 GMT

  <Prev Next>   <<First <Prev

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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023