KURT

KURT(number1 [,number2] [..)

Returns the kurtosis for a list or array of numbers.

number1The first number.
number2(Optional) The second number.

REMARKS
* The Kurtosis of a Probability Distribution indicates how much data resides in the tails.
* This function characterises the relative 'peakedness' or 'flatness' of a distribution compared with the normal distribution.
* The arguments can be either arrays, cell references or named ranges that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If there are fewer than four data points, then #DIV/0! is returned.
* If the standard deviation of the sample equals zero, then #DIV/0! is returned.
* You can have a maximum of 255 arguments.
* You can use the SKEW function to return the skewness of a distribution based on a sample.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=KURT(10, 20, 30, -20) = 1.5
2=KURT(3, 4, 5, 2, 3, 4, 5, 6, 4, 7) = -0.152
3=KURT(10, 20, 30) = #DIV/0!
4=KURT(10, 10, 10, 10, 10) = #DIV/0!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top