# Documentation/Calc Functions/KURT

KURT

## Category:

Statistical Analysis

## Summary:

Calculates the kurtosis of a data set comprising at least four values. Kurtosis is a statistical measure that is used to describe the shape of a probability distribution.

## Syntax:

KURT(Number 1 [; Number 2 [; … [; Number 255]]])

## Returns:

Returns a real number.

## Arguments:

Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers representing a random sample of distribution.

• If KURT is called with arguments that specify less than four values, the function returns a division (#DIV/0!) error.
• If a name/array/reference to a cell contains text, error value, or empty cells, then the function ignores these values.
• If a cell contains 0 then the function considers it.
• If the standard deviation of the numbers is zero then the function returns a division (#DIV/0!) error.

• The formula for KURT is:

where s = sample standard deviation

n = total number of numbers

xi = Number i

x̄ = mean value of all xi's.

• For more details on kurtosis, visit Wikipedia.

## Examples:

Formula Description Returns
=KURT(A1;A2;A3;A4;A5;A6) where A1 to A6 contains 1,2,3,4,5,6 The function calculates the kurtosis value for 1,2,3,4,5,6 -1.2
=KURT(9;7;12;15;17) The function calculates the kurtosis value for 9;7;12;15;17 -1.89273356401384
=KURT(111;111;111;111;111) The function returns a division error since all arguments have the same value which leads to a 0 standard deviation. #DIV/0!

None

## ODF standard:

Section 6.18.39, part 2

KURT