converting 1 hourly data to 3 hourly data

I have file of excel with date,hour,waveheight i need to convert avg of three hourly data set i.e each day i will get 8x3(8 data sets) instead of 24x1 (24 data sets) can anyone help me out in writing code since i am new to matlab. attached file also.

Any kind of help will be useful for me

thanks

janakiram

[darova]

Can you please show what you have done already?

Answer 1

[Ajay Kumar]

data = xlsread('www3');
data = data(:,2);
j=1;
try
    for i = 1: fix(length(data))
        newdata(i) = mean(data(j:j+2));
        j=j+3;
    end
catch
end
newdata = newdata';

new data has 2912 values. Each is average of 3 hours of original data.

[janakiram Reddy]

thanks for help kumar, it is working.

[Ajay Kumar]

My pleasure.

Please accept the answer if you got what you need. Thanks :)