Time weighted average after every 60mins

please i have a sample data as in the picture, and want to find the time weighted average after every 60 mins of the spread column

[Rik]

Sounds like a nice project. Do you have a question?

Have a read here and here. It will greatly improve your chances of getting an answer.

Answer 1

[Cris LaPierre]

Look into groupsummary. You'll probably want something like this. I'm assuming your data is in a table.

groupsummary(tblName,Date.time,'hour','mean',spread)

I wouldn't call this a weighted average, though. You'll need to provide more details about how you want to time-weight the average.

Answer 2

[Peter Perkins]

Or put the data in a timetable and use retime(tt,'hourly','mean'). If you need weights, you can write your own aggregation function for hourly aggregation.