3.5.2.21 Mean/Average

1 Description
2 Syntax
3 Parameters
4 Return
5 Example
6 See Also

Description

Returns the average of a vector.

Notes:

Mean() and Average() are functionally identical. Use either of them as you like.
Mean() and Average() functions calculate average by column. If you want to calculate the average of multiple datasets by row, you can use syntax sum(vd) to sum datasets by row and generate temporary datasets of related statistics values, and then use _mean to get the meanu value. See the sum() function for more information.

Syntax

double Mean(dataset vd)

double Average(dataset vd)

Parameters

A range, dataset or column.

Return

Returns the average of specified argument.

Example

EX1

double aa=mean(col(A));
aa=; //Should return the average value of the specified column.

EX2

mean(A1:B11)

EX3

average(join(A1:A5, A11:A15))

EX4

Suppose you have signal data in column A and indexes stored in column B and C. Fill following formula in column D's F(x) cell

average(A[B:C])

to fill column D with average values of sub-range in column A, which range between indexes col(B)[i] and col(C)[i].

EX5

// create a new workbook with 3 columns
newbook;
wks.nCols = 3;

// fill first 2 columns with datdasets
col(A) = {18, 2, 3, 19, 10, 17, 15, 16, 14, 1, 4, 17, 1, 13, 6, 12, 21, 10, 1, 15};
col(B) = data(1,20);

// search values of column A in column B, return the index;
// then set column C with average of range from B1 to the row before returned index  
csetvalue col:=col(C) formula:="average(B[1:list(A[i],B)-1])";
// column C should fill with dataset {9, 1, 1.5, 9.5, 5, 8.5, 7.5, 8, 7, 0/0, 2, 8.5, 0/0, 6.5, 3, 6, 0/0, 5, 0/0, 7.5};