Investment Studio > Expressions > Functions > Statistical > AVERAGE
float average(float data [, ...])
Returns the arithmetic mean of the data: given N data points,
| N | |||
| average = | 1 | å | datak |
| ¾ | |||
| N | |||
| k = 1 |
All elements in the argument list are converted to floats (defaulting to 0.0 if conversion fails). The list may contain array arguments, in which case each array element is treated as a separate list element.
Example
The expression
=average(1, 2, 3, 4, 5)
equals 3.