Map and Table Calculation

AGGSTD( ) or ColumnAggregateStd() function

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

TabCalc

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