The kurtosis of a data set provides a measure of the peakedness of the distribution of the data, relative to the normal distribution.
A positive kurtosis value indicates a relatively peaked distribution and a negative kurtosis value indicates a relatively flat distribution.
The Excel KURT function calculates the kurtosis of a supplied set of values.
The format of the function is :
where the number arguments are the data values for which you want to calculate the kurtosis. These can be supplied to the Kurt function either:
In Excel 2007 and later versions of Excel, the Kurt function can accept up to 255 number arguments, but in Excel 2003, the function can only accept up to 30 number arguments.
Note if logical values and text representations of numbers are typed directly into the function, they are included in the calculation. However, logical values and text representations of numbers stored within an array of cells are ignored.
Column A of the above spreadsheet on the right shows an array of data, alongside the data distribution chart.
The kurtosis of the data in column A of the spreadsheet can be calculated using the Excel Kurt function as follows :
This gives the result 0.532657874, indicating a distribution that is relatively peaked (compared to the normal distribution).
Further information and examples of the Excel Kurt function can be found on the Microsoft Office website.
If you get an error from the Excel Kurt Function, this is likely to be the #DIV/0! error :