computing the average of all each month from all data in time series

3 次查看（过去 30 天）

nada 2018-6-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405165-computing-the-average-of-all-each-month-from-all-data-in-time-series

评论： nada 2018-6-12

ssxlsx.xls

Hi, I have used xls file data..i want to make average data all each month ..for all data in time series ..like mean for all Jun , Mar....from column D. the example in file. * how i can do that*

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

per isakson 2018-6-12

编辑：per isakson 2018-6-12

See

and try the example Aggregate Timetable Data and Calculate Mean Values

请先登录，再进行评论。

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

采纳的回答

Rishabh Rathore 2018-6-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405165-computing-the-average-of-all-each-month-from-all-data-in-time-series#answer_324273

编辑：Rishabh Rathore 2018-6-12

在 MATLAB Online 中打开

Hey, I understand that you want the average of each column (representing months).

You can use mean() to do that.

For example if you want average of 2nd,3rd and 4th column you can use

avg=mean(data(:,2:4),2);

This will return a 1X3 matrix with mean of 2,3 and 4 columns respectively.

Note:- I'm assuming you are importing the data as matrix.

For more info on mean() refer mean

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

Rishabh Rathore 2018-6-12

I didn't get your point. Do you want the mean of column D?

nada 2018-6-12

yes>>I apologize maybe I did not make the necessary clarification I have a table in xls file containing month and another column D contains values for each month I want an average of the values of each month of all data. the result it be table 2 columns and 12 rows

请先登录，再进行评论。