I have a set of time-series data that I need to analyse. It consists of a whole year of data (365 days). However, each day is broken up into half-hour interval data points (48 data points/ day). I would like to run a 5-day average using Excel. However, whenever I average the values for one day and subsequently drag it down for the entire time series, the moving average merely moves one cell down, and not one whole day down (jumping 48 cells to the following day). I hope this makes sense! I have attached a screenshot showing part of a single-year dataset if it makes things clearer.
Any help at all is greatly appreciated!