Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Standard deviation: STDDEV_POP
 
From:   Rudel Simard

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016