I have an excel file which contains 4076 rows and 13 columns. I want the average of every 42 rows of every single column and then store them in a new spreadsheet.Can you help me with the code?I'm a beginner using Matlab and I don't know much.

here some of my efforts from different codes I found ... no results

Answer 1

[Image Analyst]

What about conv2()?

B = conv2(A, ones(42, 1)/42, 'valid');

[Andrei Bobrov]

+1

[Sofia Fourkioti]

Thanks,you helped me a lot !

Answer 2

[Andrei Bobrov]

B = rand(4076,13);
a = 42;

i0 = ceil((1:size(B,1))'/a);
[ii,jj] = ndgrid(i0,1:size(B,2));
out = accumarray([ii(:),jj(:)],B(:),[],@mean);

[Sofia Fourkioti]

Eventually this works too!!!Thank you very much!