KURT

Calculates the kurtosis of the values in a data set.

This is a measure of the shape of a distribution of values.

Syntax:

KURT( list )

Returns the kurtosis of the values in the list.

list may be a range of cells, an array, or a comma-separated list of values (which may contain cell references and also ranges of cells as one or more of its elements).

Example:

KURT(A1:A15)

returns the kurtosis of the contents of cells in the range A1:A15.

Note:

KURT() is implemented using a two-pass approach, first independently computing the mean value, then computing intermediate values (such as the sum of the squares, products) using the difference between each value and the mean value. This approach helps avoid many round-off errors and is also employed by Microsoft Excel 2003 and later.