mkurtosis

Syntax

mkurtosis(X, window, [biased=true], [minPeriods])

Details

Calculate the moving kurtosis of X in a sliding window.

Parameters

biased is a Boolean value indicating whether the result is biased. The default value is true, meaning the bias is not corrected.

Please see mFunctions for the parameters and windowing logic.

Returns

  • Returns a DOUBLE vector of the same length as the input when the input is a vector.

  • Returns a matrix with the same dimensions as the input when the input is a matrix.

  • Returns a table with the same schema as the input when the input is a table.

  • Returns a tuple with the corresponding structure when the input is a tuple.

Examples

m=matrix(1 9 3 100 3 2 1 -100 9 10000, 1 2 3 4 5 6 7 8 9 100);
m.mkurtosis(8);
#0 #1
3.989653641279048 1.761904761904762
3.989840910744778 1.761904761904762
6.140237905908072 6.101712240467206
m.rename!(date(2020.04.06)+1..10, `col1`col2)
m.setIndexedMatrix!()
mkurtosis(m, 8d)
label col1 col2
2020.04.07
2020.04.08
2020.04.09 1.5 1.5
2020.04.10 2.3195 1.64
2020.04.11 3.2251 1.7
2020.04.12 4.163 1.7314
2020.04.13 5.1141 1.75
2020.04.14 3.9897 1.7619
2020.04.15 3.9898 1.7619
2020.04.16 6.1402 6.1017
mkurtosis(m, 1w)
label col1 col2
2020.04.07
2020.04.08
2020.04.09 1.5 1.5
2020.04.10 2.3195 1.64
2020.04.11 3.2251 1.7
2020.04.12 4.163 1.7314
2020.04.13 5.1141 1.75
2020.04.14 3.4937 1.75
2020.04.15 3.4937 1.75
2020.04.16 5.1645 5.145

The default case of kurtosis in DolphinDB is biased (biased = true), while in pandas and Excel it is unbiased estimation, and the kurtosis value 3 of the normal distribution is subtracted.

The following example illustrates the equivalent conversion between the two when using a sliding window:

// python
m = [[1111,2], [323,9], [43,12], [51,32], [6,400]]
df = pandas.DataFrame(m)
y = df.rolling(4).kurt()

// dolphindb
m=matrix(1111 323 43 51 6, 2 9 12 32 400)
m.mkurtosis(4, false)-3
#0 #1
2.504252 2.366838
3.675552 3.941262

Related function: kurtosis