MATLAB Answers

0

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

nada seddeeq さんによって質問されました 2018 年 6 月 11 日
最新アクティビティ nada seddeeq さんによって コメントされました 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*

1 件の回答

回答者: 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 件のコメント

hi Rishabh i want loop for mean for all month Jan Corresponding, value in that D columns
I didn't get your point. Do you want the mean of column D?
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

サインイン to comment.



Translated by