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

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*

[per isakson]

See

• https://se.mathworks.com/matlabcentral/answers/384643-determine-index-of-a-value-monthly-from-excel-table#answer_307159
• retime, Resample or aggregate data in timetable, and resolve duplicate or irregular times

and try the example Aggregate Timetable Data and Calculate Mean Values

Answer 1

[Rishabh Rathore]

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

[nada]

hi Rishabh i want loop for mean for all month Jan Corresponding, value in that D columns

[Rishabh Rathore]

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

[nada]

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