calculation of 10 minute averages per day

T

tony

Hello,

I would like to calculate the average reading over each 10
minute period from a list of figures taken at 2 second
intervals throughout the day (i.e. 300 readings).
The full list could be upto 36,000 numbers in total.

The list is presented as a column and I would like the
calculation to look at the whole list and ideally to
present the results as a second column.

I will then need to review the calculated column to pick
out any averages that are above a certain reading.

Thanks, Tony
 
P

Paul

tony said:
Hello,

I would like to calculate the average reading over each 10
minute period from a list of figures taken at 2 second
intervals throughout the day (i.e. 300 readings).
The full list could be upto 36,000 numbers in total.

The list is presented as a column and I would like the
calculation to look at the whole list and ideally to
present the results as a second column.

I will then need to review the calculated column to pick
out any averages that are above a certain reading.

Thanks, Tony

Suppose your readings are in column A starting at A1. In B1, put the formula
=AVERAGE(OFFSET($A$1,300*(ROW()-1),0,300,1))
and drag this down as far as required (120 results?)
 
T

tony

Thanks,paul you're a star!
-----Original Message-----


Suppose your readings are in column A starting at A1. In B1, put the formula
=AVERAGE(OFFSET($A$1,300*(ROW()-1),0,300,1))
and drag this down as far as required (120 results?)


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top