Documentation/Calc Functions/KURT

Function name:
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.

Additional details:

 * 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.

Related LibreOffice functions:
None

ODF standard:
Section 6.18.39, part 2

Equivalent Excel functions:
KURT