how to calculating hourly average?
2 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
Azzi Abdelmalek
on 28 Jun 2015
Edited: Azzi Abdelmalek
on 28 Jun 2015
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)
3 Comments
Azzi Abdelmalek
on 28 Jun 2015
Run the code line by line, and see the result of each line; you will understand
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!