KURT Function in Excel – Calculate Kurtosis in Excel

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):

KURT( number1, [number2], … )

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):

KURT Function in Excel 1

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.

previous-small KURT Function in Excel                                                                                                                next_small KURT Function in Excel