calculation of 10 minute averages per day

  • Thread starter Thread starter tony
  • Start date Start date
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
 
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
Click to expand...

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?)
 
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?)


.
Click to expand...
 
Back
Top