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

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.

Answer 1

[Benjamin Großmann]

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 .

Answer 2

[Chris Turnes]

It sounds like what you might want to do is put your data into a timetable and use the retime function.