O'Reilly logo

Teradata SQL by Tom Coffing, Mike Larkins

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 26 - 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 KofCol1FROM 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