Moving average for uneven sampled data?

[Johan Myrberger]

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

 

[RagDyer]

If I understand what you're asking, try this, with dates in Column A and
data in Column B, and where you enter the starting date in C1 and the ending
date in D1:

=SUMPRODUCT((A1:A50>=C1)*(A1:A50<=D1)*B1:B50)/SUMPRODUCT((A1:A50>=C1)*(A1:A5
0<=D1))


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



message 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