Average 6000 data points in sets of 10
 

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.

Average 6000 data points in sets of 10
 

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

Average 6000 data points in sets of 10
 

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.

If A2:A6000 contain your data.

B2

=SUMPRODUCT(SUBTOTAL(1,OFFSET($A$2,10*(ROWS($A$2:A 2)-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)))