MATLAB: Mean value every 60 rows

meanvalues

Hello, I got my table, with 180 rows and 2 columns, each column is a variable X1, X2. I want to have the mean of X1 60 rows in 60 rows, the same for X2. This is the result media =
   60.1635
   60.1523
   60.1492
media =
513.0252
513.1533
513.1119
Question 1) How to store the results in a matrix or table 3×2 so I would have something like:
   60.1635 513.0252
   60.1523 513.1533
   60.1492 513.1119
Question 2) For example if i wanted to make the average each 120 rows, what would I need to change? is just the "n" value? because i dont understand what does the "1" do in here
      a = reshape(tabela(:,j),[],1);
Code is here:
n = 60
for j=1:2
    a = reshape(tabela(:,j),[],1);
    media = arrayfun(@(i) mean(tabela(i:i+n-1,j)),1:n:length(a)-n+1)'
end
Thanks for your help!

Best Answer

You need to do some tricks here. Firstly, your data is 181x2 and since 181 is not dividable by 60, I erased the last row to make it 180x2. Next do the following steps:
Tabela=mat2cell(tabela,60*ones(1,3),2)
Tabela_avg=cellfun(@(x) mean(x),Tabela,'uni',0)
and you will obtain the mean for each 60x2 data. You can reach all of them at once by typing
Tabela_avg{:}
If you want the first 120 rows, then you need to separate that as follows:
Tabela=mat2cell(tabela,[120 60],2)
since the sum of dimensions has to be equal to the initial size.
Related Question