Click or drag to resize
sqx

SQXMeansDevsTable Method

Function [table] MeansDevsTable([Matrix] MeansDevsMatrix)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static IEnumerator MeansDevsTable(
	Matrix MeansDevsMatrix
)

Parameters

MeansDevsMatrix
Type: sqxMatrix
[Matrix]

Return Value

Type: IEnumerator
[table]
Remarks

Attributes

IsDeterministic = true, IsPrecise = true, DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, TableDefinition = "ID int,Mean float,StDev float,StError float,MinValue float,MaxValue float"
Examples
SQL
Copy
declare @Query nvarchar(max) = N'
select a.Value [1],b.Value [2],c.Value [3]
from sqx.VectorTable(sqx.RandomVector(10,1)) a
inner join sqx.VectorTable(sqx.RandomVector(10,2)) b ON a.ID = b.ID
inner join sqx.VectorTable(sqx.RandomVector(10,3)) c ON a.ID = c.ID
'
declare @A sqx.Matrix
exec sqx.MeansDevsMatrix @Query = @Query, @Population = 1, @SnapShot = 0, @MeansDevsMatrix = @A OUTPUT
exec sqx.MatrixToTable @A
select * from sqx.MeansDevsTable(@A)
/*
ID          1                      2                      3
----------- ---------------------- ---------------------- --------------------
1           0.472999690693337      0.422586420468328      0.472173150243318   Avg    
2           0.266302897902179      0.311228643259885      0.265228430997687   StDevp
3           0.0842123704874163     0.0984191385785249     0.0838725942185496  StError
4           0.101266453555444      0.0112066529743404     0.180578214666144   Min
5           0.943862276125635      0.985047052607428      0.947231081755474   Max

ID          Mean                   StDev                  StError                MinValue               MaxValue
----------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
1           0.472999690693337      0.266302897902179      0.0842123704874163     0.101266453555444      0.943862276125635
2           0.422586420468328      0.311228643259885      0.0984191385785249     0.0112066529743404     0.985047052607428
3           0.472173150243318      0.265228430997687      0.0838725942185495     0.180578214666144      0.947231081755474*/
See Also