How to make a softer plot using a moving average every ''x'' skips?

1 view (last 30 days)
Guillermo Renderos
Guillermo Renderos on 22 Mar 2018
Answered: Chris Turnes on 24 Apr 2018
I have a table from excel from values every 15 minutes from a whole year, the excel table only have 2 columns: DATETIME and VALUE. But when I plot the data, the shape of the plot has a very sharp form. The simplest solutios to make the plot softer, I think, is to calculate the mean for every hour (4 values) and plot them. After searching I found the function tsmovavg, but this function don't do the skip every 4 values, instead of that, can calculate the mean of the last 4 positions of the vector. How can I do to make my script possible?.If you have and example of something very similar to this I would be very greatful to see it.

Answers (2)

Benjamin Großmann
Benjamin Großmann on 24 Apr 2018
If you have signal processing toolbox than you can use moving average filter or more advanced filtering techniques as described here
If not, than it is also easy to smooth this signal using methods and functions described here e.g.: movemean or smoothdata .

Chris Turnes
Chris Turnes on 24 Apr 2018
It sounds like what you might want to do is put your data into a timetable and use the retime function.

Community Treasure Hunt

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

Start Hunting!