- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to get a average for part of column data by using formula
For example, I have a column:
2
3
4
50
60
70
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
3
4
50 60
60
70
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to get a average for part of column data by using formula
Try this:
If(Modulo(Row(), 3) == 1,
Col Mean(:Column 1, Ceiling(Row() / 3))
)
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to get a average for part of column data by using formula
@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));
Best
Uday
Uday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to get a average for part of column data by using formula
Try this:
If(Modulo(Row(), 3) == 1,
Col Mean(:Column 1, Ceiling(Row() / 3))
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to get a average for part of column data by using formula
Thanks! It works!