|
If keyword is ALL, AVG returns one new column, containing a single value (the average deviation of all cells in data).
|
|
If keyword is COL, AVG returns a new column for each input column. Each new column contains one value (the average deviation of all cells in the corresponding input column).
|
|
If keyword is ROW, AVG returns one new column containing the average deviation across each row of data.
|
TEMP = AVG_DEV(MERGE(3, 4, 5)) or TEMP = AVG_DEV(MERGE(3, 4, 5), ALL)
|
Creates a new column named TEMP containing a single value which is the average deviation of the contents of column V1.
|
Creates a new column named TEMP containing a single value which is the average deviation of the contents of columns V1, V2, and V3.
|
Creates a new column named TEMP containing a single value which is the average deviation of the cells in rows 10-20 of column V1.
|
Creates a new column named TEMP containing a single value which is the average deviation of the cells in rows 1-5 of columns V1 through V4.
|
Creates three new columns named TEMP, VX, and VY. The single value in the TEMP column is the average deviation of the contents of column V1, the single value in the VX column is the average deviation of the contents of column V2, and the single value in the VY column is the average deviation of the contents of column V3.
|
Creates three new columns named TEMP, VX, and VY, each containing a single value. The value in column TEMP is the average deviation of the cells in rows 1-5 of column V1, the value in column VX is the average deviation of the cells in rows 1-5 of column V2, and the value in column VY is the average deviation of the cells in rows 1-5 of column V3.
|
Creates a new column named TEMP, containing a zero for each value of column V1 (the average deviation of any number is zero).
|
Creates a new column named TEMP where each cell entry is the average deviation of the corresponding row across columns V1, V2, and V3.
|
Creates a new column named TEMP, where the cells in rows 1-5 contain the average deviation of the corresponding row across columns V1 through V3. The other cells in TEMP are empty.
|
AVG or MEAN
|
|
SUM or TOTAL
|
Copyright IBM Corporation 2013. All Rights Reserved.
|