CODEWITHSUNDEEP
excelvbaexcel-2013
Stacker
Stacker

Reputation: 113

With Excel 2013, How can I get the average of one column that is every 5 seconds averaged into every 10 minutes?

So, I have one column (column B) that records the DATETIME of each recorded instance. I then have another column (Column c) with the vardata. See pic attached:
pic example

I want to get all those varValues averaged every 10 mins, instead of every 5 seconds. Any ideas?

Thanks

Upvotes: 0

Views: 56

Answers (1)

Forward Ed
Forward Ed

Reputation: 9874

=AVERAGE(C1:C120)

place that in column C1 and copy down. You will get a moving average over a ten minute period in 5 second increments.

Alternatively if you want to grab the first 10 minutes and get and average of your averages, and then grab the next 10 minute increment then you could do:

=AVERAGE(INDEX(C:C,(ROW(A1)-1)*120+1):INDEX(C:C,ROW(A1)*120))

When copying down and it starts producing errors, you have probably run out of data.

NOTE: This only works if there are always 120 entries per period as its not looking at the time stamp but simply working with the fact that there are 120 5 second entries in a 10 minute period.

Upvotes: 1

Related Questions