KURT Function in Excel calculates the Kurtosis of supplied sets of values.
KURTOSIS:
The kurtosis is a measure of the peaked ness 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.
Syntax of KURT Function in Excel (KURTOSIS Function in Excel):
Where number arguments are the values for which you want to calculate the kurtosis for.
Example of KURT Function in Excel (KURTOSIS Function in Excel):
Column A has an array of data. The kurtosis of this data can be calculated using the Excel Kurt function.
=KURT( A2:A16 )
As shown in the above example. This result in the value of 0.757671, which indicates relatively high peaked ness.
NOTE:
- #DIV/0! – Occurs if the supplied data set has less than 4 data points.