Kurtosis() returns the kurtosis of the data in the expression over a number of records as defined by a group by clause.
Return data type: numeric
|expr||The expression or field containing the data to be measured.|
|distinct||If the word distinct occurs before the expression, all duplicates will be disregarded.|
Examples and results:
Add the example script to your app and run it. To see the result, add the fields listed in the results column to a sheet in your app.
crosstable LOAD recno() as ID, * inline [
25|2 ] (delimiter is '|');
Kurtosis(Value) as MyKurtosis1,
Kurtosis(DISTINCT Value) as MyKurtosis2
Resident Table1 Group By Type;
In a table with the dimensions Type, MyKurtosis1,and MyKurtosis2, the results of the Kurtosis() calculations in the data load script are:
Type MyKurtosis1 MyKurtosis2
Comparison -1.1612957 -1.4982366
Observation -1.1148768 -0.93540144