Archives of the TeradataForum

Message Posted: Thu, 10 Apr 2003 @ 08:56:24 GMT

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

Hello Elise,

I found the definition in Teradata RDBMS SQL Reference Volume 5 - Chapter 6 Aggregate Functions - page 6-51 Skew

There the formula is more readable.

Excuse me, but there was an error in my copy of the formula, correct is:

SKEW = (COUNT(x) / (COUNT(x) - 1) * (COUNT(x) - 2)) * SUM(((x - AVG(x)) / STDDEV_SAMP(x)**3)

In the same chapter you will find also the definitions for all the statistic functions (variance, regression, standarddeviation,...)

Ulrich Lickert

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