Hi,
the methods in Excel for calculating moving average seems all to
calculate the average for a number of samples. This is not helping me
when I have a set of data (readings from different meters) taken at more
or less random dates. I'd like to calculate the moving average for using
eg 3 month as the window.
The only way to work around this that I have found is to generate a
second set of data from the first, where I interpolate data for every
date between two actual data. This is a bit clumpsy in my mind...
Is there a way to calculate moving average for uneven sampled data like
in my case?
regards
/Johan Myrberger
Bookmarks