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

1 次查看（过去 30 天）
nada
nada 2018-6-11
评论： nada 2018-6-12
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*

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

采纳的回答

Rishabh Rathore
Rishabh Rathore 2018-6-12
编辑：Rishabh Rathore 2018-6-12
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更早的评论
nada
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

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Preprocessing 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by