next up previous contents index
Next: CAVG Up: A. Function Reference Previous: ATANH   Contents   Index


AVG, AVERAGE

Syntax: AVG(argumentlist)
  AVERAGE(argumentlist)

argumentlist = any combination of numbers, cells, or ranges

AVG returns the average (arithmetic mean) of its arguments. Blank cells and strings are ignored. The function is given by:

\begin{displaymath}
\left( \sum_{i=1}^N a_i \right)/N
\end{displaymath}

AVERAGE is a synonym for AVG.

Examples:

AVG(A1, B9, J32, F16) = 21.125, where A1 = 12, B9 = 34.5, J32 = 22, F16 = 16

AVG(A1, A12..H13, 111+32) = 135.67, where we don't really care what is at those variables, but which shows that you can use numbers, ranges, and expressions all together as arguments for AVG.

Excel function: AVERAGE


next up previous contents index
Next: CAVG Up: A. Function Reference Previous: ATANH   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003