Excel Kurtosis 3. KURTPR excess kurtosis of the distribution for the population in range R1. As Alecos notes in comments some people define kurtosis as E Z 4 3.
Contrary to popular belief sample excess kurtosis does not equal sample kurtosis less 3 as it is with population kurtosis but you. If your distribution has a kurtosis greater than 3 it has a positive excess kurtosis and is called leptokurtic. Peak is higher and sharper than Mesokurtic which means that data are heavy-tailed or profusion of outliers.
If you want to calculate population non-excess kurtosis in Excel you simply take population excess kurtosis that weve just calculated above and add 3 because.
This is calculated on the data set of the investment. Returns the kurtosis of a data set. When both skewness and kurtosis are zero a situation that researchers are very unlikely to ever encounter the pattern of responses is considered a normal distribution. If your distribution has a kurtosis of less than 3 it has a negative excess kurtosis and is called platykurtic.
