1,2, and 3 day moving averages

[bio916]

Hi All,

I have 15 min data and I need to calculate 1,2, and 3 day moving averages based off of hourly updates. The excel moving average function updates moving averages every 15 min. For example it asked for a interval and I input 97 (# of 15min entries in a day) and it averages =Average(B2:B99), =Average(B3:B100), =Average(B4:B101), etc. I would like a moving average like this but based on hourly updates not 15 min., is this possible?

30+ days of data is formatted like:

Date (col A) Data (col B)

10/3/02 20:45 73.28
10/3/02 21:00 72.98
10/3/02 21:15 73.33
10/3/02 21:30 73.03
10/3/02 21:45 73.28
10/3/02 22:00 73.21
10/3/02 22:15 73.21
10/3/02 22:30 73.34
10/3/02 22:45 73.01
10/3/02 23:00 72.95
10/3/02 23:15 72.95
10/3/02 23:30 73.29
10/3/02 23:45 73.27
10/4/02 0:00 73.21
10/4/02 0:15 73.09
10/4/02 0:30 73.43
10/4/02 0:45 73.42
10/4/02 1:00 44.66
10/4/02 1:15 10.33
10/4/02 1:30 10.33
10/4/02 1:45 10.33
10/4/02 2:00 10.33
10/4/02 2:15 10.33
10/4/02 2:30 10.33

Any help with a formula would be much appreciated, Thanks!

[HansDouwe]

For 1-day average try in Cell C98 and copy down:

Please Login or Register  to view this content.

etcetera.