Calculating Monthly average from daily data

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 :(

[darova]

DOn't remove your question. Let it be. Restore it if possible

[John D'Errico]

When you remove your question, you make the answer useless, out of context. That is an insult to the person who spent the time to answer your question. It damages Answers as a site for others to gain from, because nobody else can learn from this answer. An answer is meaningless without the context of the question behind it.

If you cannot stomach leaving your question there for others to see, you should not have asked the question in a public forum in the first place.

[darova]

The main thing for me is accepting my answer

[Rena Berman]

(Answers Dev) Restored edit

[darova]

thanks

Answer 1

[darova]

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