How do I calculate 30 minute average from 10 minute data??

I have excel file 10 minute data. 1st column is date and time and 2nd onward data. From 10 minute data, I want to calculate 30 minute average. For reference please find attachment of input file and out put file.

[Jan]

Did you import the Excel files to Matlab already? Do you want the results in Matlab or export them to Excel again? Do you want a moving average or not?

move_Av  = [mean(data(1:3)), mean(data(2:4)), mean(data(3:5))]
block_av = [mean(data(1:3)), mean(data(4:6)), mean(data(7:9))]

It would be easier, if you explain this instead of letting us struggle with Excel files.

[S SNO]

I am beginner to do programing in matlab. No I not import the Excel files to Matlab. I want result in excel file. I have 7516 row and 24 column in my original excel file. i don't want moving average.

[Image Analyst]

I don't understand. Do you or do you not have an original Excel file that you want to import into MATLAB with xlsread()? After you process your numbers in MATLAB (regardless of how they got there), do you or do you not want to export them to an Excel workbook with xlswrite()?

And how do you propose to compute means of 30 minute sections if you don't use a moving mean?

Answer 1

[Image Analyst]

Nothing was attached. You can use movmean() or conv()

smoothedData = conv(data, [1, 1, 1] / 3, 'same');

[DINUMOL VARGHESE]

Sir, i imported the power curve from excel and i need to do moving average in matlab and show the results.how is it possible

[Image Analyst]

You can use my code above, or use the newer movmean().

To show the results, why not use plot()?

Answer 2

[Jan]

If you really want to use an Excel file as input and as output, it would be much easier to do this in Excel: http://www.excel-easy.com/examples/moving-average.html