calculation of a mean

Question

ShayanA 2018-11-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/429610-calculation-of-a-mean

评论： ShayanA 2018-11-14

Hi, i have a column with 26668626 rows and 1 column which i will load from an excel file. after i loaded the data wanne have avrage av every 10th row to the end.i wish to put to the new colum.

tried with differet code but the result was not right.

Can someone sopported ?

Thanks Shayan

3 个评论
显示 1更早的评论隐藏 1更早的评论

ShayanA 2018-11-14

Thanks for you answer and tip. Perhaps i was not to clear with my question but option 2 is what i wanne do.have a avrage of row segment in groups 1 to 10 & 11 to 20 , 21 to 30 and etc

//Shayan

madhan ravi 2018-11-14

did you see the answer below ? it has exactly what you need

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2018-11-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/429610-calculation-of-a-mean#answer_346719

26668626 isn't evenly divisible by 10; what do you want to do with the leftover 6 elements? You also can't add a column of 1/10th the length of the rest of the array onto the existing array.

Ignoring those last six,

mnx=reshape(mean(reshape(x(1:fix(length(x)/10)),10,[]),1,[]);

will return a column vector of means of each 10 successive elements, ignoring the last six.

Can append mean of those last onto the end or augment the original array to next multiple of 10 with NaN and use nanmean() instead on the resulting array of 26668630 elements.