O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 40 - Statistical Aggregate Functions

“It's not that figures lie, it's that liars figure.”

-Anonymous

The Stats Table

images

Above is the Stats_Table data in which we will use in our statistical examples.

The KURTOSIS Function

SELECT KURTOSIS(col1) AS KofCol1
FROM Stats_Table;

 

 

 

The KURTOSIS function is used to return a number that represents the sharpness of a peak on a plotted curve of a probability function for a distribution compared with the normal distribution.

A high value result is referred to as leptokurtic, a medium result is referred to as mesokurtic, and a low result is referred to as platykurtic.

A positive value indicates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required