Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: What is Skew factor?
From:   Lickert, Ulrich

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