Click or drag to resize
sqx

DEV Structure

Aggregate [float] DEV([float] Value, [bit] Population, [smallint] Method)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct DEV : IBinarySerialize
Remarks
Deviations aggregate function.
Method:
  • 1 - Standard Deviation.
  • 2 - Modified Standard Deviation from Median.
  • 3 - Median Absolute Deviation from Median.
  • 4 - Mean Absolute Deviation from Median.
  • 5 - Median Absolute Deviation from Mean.
  • 6 - Mean Absolute Deviation from Mean.
  • 7 - Max Absolute Deviation from Mean.
  • 8 - Max Absolute Deviation from Median.
  • 9 - Mode Standard Deviation from Mode.
  • 10 - Standard Deviation of Logs. (Value > 0)
  • 11 - Logarithmic Median Absolute Deviation from Median. (Value > 0)
  • 12 - Logarithmic Mean Absolute Deviation from Median. (Value > 0)
  • 13 - Max Absolute Value
  • 14 - Standard Deviation from Trimean (Method 2)
  • 20 - Standard error of the Mean.
  • 21 - Standard error of the Median.
  • 22 - Coefficient of Variation.
  • 23 - Coefficient of Dispersion (Median).
  • 24 - Variance to Mean ratio AKA Index of Dispersion.
  • 25 - Hoover Index H.

Population: 1 = (1/N) | 0 = (1/(N-1)).


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
See Also