Documentation/Calc Functions/KURT

From The Document Foundation Wiki
Jump to: navigation, search

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:
Kurt.png

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!

Related LibreOffice functions:

None

ODF standard:

Section 6.18.39, part 2

Equivalent Excel functions:

KURT