Calculating Monthly average from daily data
11 views (last 30 days)
Show older comments
Hi, I am having problem with calculating monthly average from daily data
I have a data set Matrix [year month day value].
I want to calculate every monthly average from daily data.
Problem is, 1 month have 28 29 30 31 days. I have 40 years data.
Help me :(
5 Comments
Accepted Answer
darova
on 27 May 2020
Edited: darova
on 27 May 2020
Try this
k = 1;
month(end+1,:) = month(end,:)*nan;
s = 0;
for i = 1:length(month)-1
s = s + value(i);
if month(i) ~= month(i+1) % if next month
month(k:i,2) = s/(i-k+1); % calculate average and write to 2d column
s = 0; % rest sum varibale
k = i; % month counter (start)
end
end
0 Comments
More Answers (0)
See Also
Categories
Find more on Line Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!