Click or drag to resize
sqx

GE Structure

Aggregate [float] GE([float] Value, [float] Alpha)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct GE : IBinarySerialize
Remarks
Generalized entropy index aggregate function.

NOTE: All parameters except Value must remain constant within the GROUP BY.

Attributes

Format.UserDefined, IsInvariantToDuplicates = false, IsInvariantToNulls = true, IsInvariantToOrder = true, IsNullIfEmpty = true, MaxByteSize = -1
Examples
SQL
Copy
SELECT sqx.GE(Value, 0) MLD /* Mean Log Deviation */
, sqx.GE(Value, 2) HalfSquareCV /* Half Square Coefficient of Variation */
, sqx.OneFloat() - EXP(-sqx.GE(Value, 0)) AtkinsonIndex /* Atkinson Index for 0 <= Alpha < 1 */
, sqx.GE(Value, 1) TheilIndex
FROM sqx.UTable(100,0)
/*
MLD                    HalfSquareCV           AtkinsonIndex          TheilIndex
---------------------- ---------------------- ---------------------- ----------------------
0.22195618689344       0.129494596034123      0.199049544306413      0.152183025012593*/
See Also

Reference

sqx Namespace