The Excel KURT Function

Kurtosis

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 kurtosis is described further on the Wikipedia kurtosis page.

Function Description

The Excel KURT function calculates the kurtosis of a supplied set of values.

The syntax of the function is:

KURT( number1, [number2], ... )

where the number arguments are a minimum of four data values for which you want to calculate the kurtosis.

Each of the number arguments can be an individual numeric value or an array of values. These can be supplied to the Kurt function either:

Note:


Kurt Function Examples

Kurt Function Example Data

Column A of the above spreadsheet on the right shows an array of data, alongside the associated data distribution chart.

The kurtosis of the data in column A of the spreadsheet can be calculated using the Excel Kurt function as follows:

=KURT( A1:A12 )

This gives the result 0.532657874, indicating a distribution that is relatively peaked (compared to the normal distribution).


For further details and examples of the Excel Kurt function, see the Microsoft Office website.


Kurt Function Errors

If you get an error from the Excel Kurt Function, this is likely to be one of the following:

Common Error
#DIV/0!-

Occurs if either:

  • There are fewer than 4 data points in the supplied data set;
  • The sample standard deviation of the supplied data set is 0.
#VALUE!-

Occurs if any of the supplied number arguments that are supplied directly to the function are not recognised as numeric values.

(Although, if the Kurt function is provided with a reference to a range of cells, any text values within this cell range are simply ignored and do not cause the function to return an error).