topic How to get a average for part of column data by using formula in Discussions

How to get a average for part of column data by using formula

jasongao — Tue, 08 Jan 2019 22:17:44 GMT

For example, I have a column:

would like to get the average for every 3 rows, and put the average in a new column in first row in every set by using formua, like this:

2 3

50 60

uday_guntupalli — Tue, 08 Jan 2019 22:41:22 GMT

@jasongao,
One way would be something like this:

You will need to extract your data from column into a matrix. You can do that using << get as matrix command.

Mat = [2,3,4,50,60,70] ; 

NewMat = Transpose(Shape(Mat,(N Rows(Mat) * N Cols(Mat))/3,3 )); 

V Mean((NewMat));

ms — Tue, 08 Jan 2019 23:15:57 GMT

Try this:

If(Modulo(Row(), 3) == 1,
    Col Mean(:Column 1, Ceiling(Row() / 3))
)

jasongao — Wed, 09 Jan 2019 00:35:53 GMT

Thanks! It works!