cancel
Showing results for
Did you mean:

# Kurtosis Greg_Deckler
Super User
356 Views
Highlighted Super User

## Kurtosis

Simply stated, Kurtosis is a measure of the degree to which a given distribution is more or less "peaked" relative to the normal distribution. This is an important measure that can have implications on what sorts of statistical methods are appropriate to use on the sample distribution.

The presented Quick Measure has three measures, Sample Kurtosis, Excess Kurtosis and Kurtosis Type:

```Sample Kurtosis =
VAR __mean = AVERAGEX(ALL('Data'),[Values])
VAR __stddev = STDEVX.P(ALL('Data'),[Values])
VAR __n = COUNTROWS(ALL('Data'))
VAR __table = ADDCOLUMNS('Data',"__skew",POWER(([Values]-__mean),4))
VAR __sum = SUMX(__table,[__skew])
RETURN
DIVIDE(__sum,POWER(__stddev,4),0) * DIVIDE(1,__n,0)```

`Excess Kurtosis = [Sample Kurtosis] - 3`

```Kurtosis Type =
SWITCH(TRUE(),
[Excess Kurtosis]>0,"Leptokurtic",
[Excess Kurtosis]<0,"Platykurtic",
"Mesokurtic"
)```

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!