Calculating an average for specific time intervals

[GoAggieBlue0815]

In column C I have a set values in 15 minute increments. I want to get an average of column C in different time increments. For example, if I wanted a 15 minute average, I need it to average C1:C2, then C2:C3, then C3:C4 and so on. If in was for 60 minutes, I need it to average C1:C4, then C2:C5, then C3:C6 and so on.
I have been having a lot of trouble trying to figure this out... Can anybody help me? Thank you

 

[NBVC]

I am not sure if your 15 minute interval sample is correct or your 60 minute interval sample. They are not both the same.

So if for 15 minutes, C1:C2 is correct, then for 60 minutes, I think you want C1:C5 and so you can use formula:

=AVERAGE(C1:INDEX(C:C,ROW(C1)+$F$1/15))

copied down, where F1 would contain your interval (e.g. 15 for 15 minutes).

If you really want C1:C1 for 15 minutes and C1:C4 for 60, then try:

=AVERAGE(C1:INDEX(C:C,ROW(C1)+$F$1/15)-1)

 

[candybg]

I would call these numbers "Rolling Averages".
I would use Col D to give you the 15 min rolling averages and Col E to give you the 60 min rolling averages.
Assuming:
- your figures start in C1
- each line is a 15 min period
15 min average
Then the formula in D2 (so it always looks backwards) would be:
=AVERAGE(C1:C2)
then copy that formula on down the column.

60 min average
Your first formula in Col E would start in E4 (again to look at the last 4 15-min periods) would be:
=AVERAGE(C1:C4)
Then that formula is copied down the column

Hope this helps!