MATLAB Answers

Time weighted average after every 60mins

4 views (last 30 days)
Kwasi Boateng
Kwasi Boateng on 27 Oct 2020
Answered: Peter Perkins on 20 Nov 2020
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

  1 Comment

Rik
Rik on 27 Oct 2020
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.

Sign in to comment.

Answers (2)

Cris LaPierre
Cris LaPierre on 27 Oct 2020
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.

  0 Comments

Sign in to comment.


Peter Perkins
Peter Perkins on 20 Nov 2020
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.

  0 Comments

Sign in to comment.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!