Click or drag to resize
sqx

TRIMEAN Structure

Aggregate [float] TRIMEAN([float] Value, [smallint] Method)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct TRIMEAN : IBinarySerialize
Remarks
Trimean aggregate function.
Quartile Method:
  • 1 - This rule is also applied by QUARTIL.EXC function in Excel after Office 2010.
  • 2 - (Tukey's hinges). This rule is applied by Excel before Office 2010 and by the QUARTIL.INC function after Office 2010.
  • 3 - For odd N arithmetic mean of Methods 1 and 2.

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