|
|
Archives of the TeradataForum
Message Posted: Fri, 05 Aug 2005 @ 14:36:53 GMT
Subj: | | Re: Standard Deviation |
|
From: | | Victor Sokovin |
| I'm looking for the standard deviation of the values of a column in a teradata table. Does Teradata have a standard deviation function?
If not, any suggestions on how to do this? | |
The functions are: STDDEV_POP and STDDEV_SAMP.
The discussions in that thread and the one which was quoted in it were about the typo in the documentation. It looks like TD always calculated
the deviation correctly but some users were confused by the incorrect formula in the documentation. I see that the formula is now correct in the
latest edition of the documentation. If you would like to find out more on these and all the other functions in Teradata, read the "SQL Reference:
Functions and Operators" manual.
Regards,
Victor
| |