Map and Table Calculation

AVG( ) function

Returns the average (arithmetic mean) of a value column.

Syntax

AVG(ValueColumn)

Input

ValueColumn	is a value column
Domain type:	any Value domain

Output

AVG returns:	a real value
Domain:	system domain Value

Notes:

The average is calculated according to the following formula:

The AVG function can only be used on the command line of a table window; it cannot be used on the command line of the Main window.
The AVG function can also be performed through a dialog box, see Column Statistics.
When the input value is undefined, the value is excluded from the calculation.

Tips:

To calculate weighted averages or averages per class, see the AGGAVG function.
When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.

Usable in

TabCalc, TabCalc pocket line calculator

Examples

TabCalc example:

OutCol = AVG(InCol)

InCol	OutCol
-5	3
-2	3
-1	3
0	3
?	3
4	3
8	3
9	3
11	3

TabCalc Pocket line calculator example:

? AVG(InCol)

returns 3.000

See also:

MIN	CNT	VAR	TTEST
MAX	STD	COV	CHISQUARE
SUM	STDEV	COVAR	Column Statistics
CUM	STDERR	CORR	AGGAVG