ave

 

Description:

The ave function breaks dataset into groups of size size, finds the average for each group, and returns a range containing these values.

Syntax:

dataset ave(dataset vd, int size[, int stats])

Parameters:

vd

A dataset, or a range pointing to a single dataset.

size

An integer for the number of elements in each group. If the dataset size is not an even multiple of group size, then the final average will represent only mod(DatasetSize,GroupSize) elements.

stats

1 (default): mean, 2: sd, 3: se, 4: min, 5: max, 6: median, 7: sum, 8: RMS

Return:

Returns a dataset.

Examples:

//group every 5 points in column A and return average of each group to column B 
col(B) = ave(col(A),5); 
//return the maximum by week 
col("Weekly") = ave(col("Days"),7,5);

//group every 100 points in 2nd column and return SD of each group to 3rd column
col(2) = int(65 + 35 * uniform(5000));
col(3) = ave(col(2),100,2);

See Also:

Sum (function), Sum (object)