Returns the standard deviation of an entire column, standard deviations per group, the weighted standard deviation, or weighted standard deviations per group.
Syntax
AGGSTD(ValueColumn)
AGGSTD(ValueColumn, Group)
AGGSTD(ValueColumn, , Weight)
AGGSTD(ValueColumn, Group, Weight)
ColumnAggregateStd(ValueColumn)
ColumnAggregateStd(ValueColumn, Group)
ColumnAggregateStd(ValueColumn, , Weight)
ColumnAggregateStd(ValueColumn, Group, Weight)
Input
ValueColumn | is a value column |
Domain type: | any Value domain |
Group | is the 'group by' column |
Domain type: | any Class, ID, Group or Bool domain |
Weight | is the weight column |
Domain type: | any Value domain |
Output
AGGSTD(ValueColumn) or ColumnAggregateStd (ValueColumn) |
|
returns: |
the standard deviation of a column |
Domain: | system domain Value |
AGGSTD(ValueColumn, Group) or ColumnAggregateStd (ValueColumn, Group) |
|
returns: |
standard deviations per group |
Domain: | system domain Value |
AGGSTD(ValueColumn, , Weight) or ColumnAggregateStd (ValueColumn, , Weight) |
|
returns: |
a weighted standard deviation |
Domain: | system domain Value |
AGGSTD(ValueColumn, Group, Weight) or ColumnAggregateStd (ValueColumn, Group, Weight) |
|
returns: |
weighted standard deviations per group |
Domain: | system domain Value |
Notes:
Tips:
Usable in
Examples
TabCalc example:
OutCol1 = AGGSTD(Area)
OutCol2 = AGGSTD(Area,Landuse)
OutCol3 = AGGSTD(Area,,Weights)
OutCol4 = AGGSTD(Area,Landuse,Weights)
Parcel |
Landuse |
Area |
Weights |
OutCol1 |
OutCol2 |
OutCol3 |
OutCol4 |
00123 |
Residential |
4000 |
2 |
6733.0 |
1779.5 |
6128.9 |
1604.7 |
00124 |
Residential |
3500 |
1 |
6733.0 |
1779.5 |
6128.9 |
1604.7 |
00125 |
Commercial |
17500 |
4 |
6733.0 |
? |
6128.9 |
0.0 |
00126 |
Residential |
7500 |
1 |
6733.0 |
1779.5 |
6128.9 |
1604.7 |
00127 |
Industrial |
20000 |
? |
6733.0 |
? |
6128.9 |
? |
01272 |
Institutional |
12500 |
2 |
6733.0 |
? |
6128.9 |
0.0 |
04625 |
Residential |
5000 |
1 |
6733.0 |
1779.5 |
6128.9 |
1604.7 |
See also:
AGGPRD | ||
AGGSUM | ||
Aggregate Column (dialog box) |