how to calculating hourly average?

Hi all, I have an observed (obs) data those were tooke every 6 min and the predicted (pred) data were recorded every 1 hr I want to take the average hour to calculate the residusl (r) by taking an obs. every 10 values corresponding to 1 value in the pred. those are also including NaN values (obs)

anyone can help me I will approciate it

thank you

Answer 1

[Azzi Abdelmalek]

v=randi(9,1,55) % Example
n=ceil(numel(v)/10)*10
v(end+1:n)=nan
a=reshape(v,10,[])
idx=~isnan(a)
for k=1:size(a,2)
  out(k)=sum(a(idx(:,k),k))/sum(idx(:,k))
end

Or

v=randi(9,1,55) % Example
n=ceil(numel(v)/10)*10
v(end+1:n)=nan
a=reshape(v,10,[])
out=nanmean(a)

[Lilya]

pardon Mr. Azzi can you give me more explanation thank

[Azzi Abdelmalek]

Run the code line by line, and see the result of each line; you will understand

[Lilya]

ok thank you there is one thing please if I want plot the new matrix with the predicted I just only take (a) corresponding to pred matrix?