The Excel KURT Function

Related Function:
SKEW 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.


Basic Description

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

The format of the function is :

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

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 Excel 2010, 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.


Kurt Function Example Data

Kurt Function Examples

Column A of the 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 :

=KURT( A1:A12 )

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.


Kurt Function Error

If you get an error from the Excel Kurt Function, this is likely to be the #DIV/0! error :

Common Error
#DIV/0! - Occurs if either:
- there are fewer than 4 data points in the supplied data set
or
- the standard deviation of the supplied data set is 0
Return to the Excel Statistical Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net