Average 6000 data points in sets of 10

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hallo everyone,
I have 6000 data points, which is too much. The data points are aligned with
a time line. It measures 10 times a second. I want to take the average of
each second (so ten data points) how do I do that?

I can't do it manually and if I use the average function it averages the
first 10 and then 2-11 while it should average 10-20 and so on.

Please help, Thank you.
 
Hi Vikash,

I'm sure this can be tidied up, but, one way, is with
your data in A1:A6000.

In B10 put =AVERAGE(A1:A10)
Then highlight B1 to B10
Grab the fill handle and drag to the end of your data
Then use autofilter to compact column B and then copy it
to somewhere usable.

HTH
Martin
 
Vikash เขียน:
Hallo everyone,
I have 6000 data points, which is too much. The data points are aligned with
a time line. It measures 10 times a second. I want to take the average of
each second (so ten data points) how do I do that?

I can't do it manually and if I use the average function it averages the
first 10 and then 2-11 while it should average 10-20 and so on.

Please help, Thank you.
Click to expand...

If A2:A6000 contain your data.

B2

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(ROWS($A$2:A2)-1),0,10,1)))

Copy down.

If B1 is represent number of next 10 cells (1 --> 1-10, 2 -->
11-20...) that can manual change the number what you want and show
result in B2 only.

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(B1-1),0,10,1)))
 
Back
Top