Click or drag to resize
sqx

MEANDEV Structure

Aggregate [Vector] MEANDEV([float] Value, [bit] Population)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
[SerializableAttribute]
public struct MEANDEV
Remarks
Mean, Standard Deviation, Standard Error, Min and Max aggregate funtion.

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

Attributes

Format.Native, IsInvariantToDuplicates = false, IsInvariantToNulls = true, IsInvariantToOrder = true, IsNullIfEmpty = true
Examples
SQL
Copy
declare @Va sqx.Vector = sqx.RandomVector(100,1)
select b.*
from (select sqx.MEANDEV(Value,1) MD from sqx.VectorTable(@Va)) a
cross apply sqx.VectorTable(a.MD) b
/*
ID          Value
----------- ----------------------
1           0.486813908739394      Avg
2           0.297475185052733      StDevp
3           0.0297475185052733     StError
4           0.00760086765866767    Min
5           0.997891051228107      Max*/
See Also