AVG
|
Single value in a new column for the ALL keyword; one column with a single value for each input column for the COL keyword; one column with a value for each row for the ROW keyword. |
Computes the arithmetic mean or average of a range of cells |
MAX
|
Single value in a new column for the ALL keyword; one column with a single value for each input column for the COL keyword; one column with a value for each row for the ROW keyword. |
Computes the maximum of a range of cells |
MEAN
|
Single value in a new column for the ALL keyword; one column with a single value for each input column for the COL keyword; one column with a value for each row for the ROW keyword. |
Computes the arithmetic mean or average of a range of cells |
MIN
|
Single value in a new column for the ALL keyword; one column with a single value for each input column for the COL keyword; one column with a value for each row for the ROW keyword. |
Computes the minimum of a range of cells |
STDV or STDEV |
Single value in a new column for the ALL keyword; one column with a single value for each input column for the COL keyword; one column with a value for each row for the ROW keyword. |
Computes the standard deviation of a range of cells |