Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.


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

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