View Single Post
  #1   Report Post  
Nathan D
 
Posts: n/a
Default creating intervals and calculating averages

Hello,
I have a set of data looking like this:
distance Deflection
0 1
2 3
5 2
11 7
14 6
19 15
23 8

etc.
so basically the distance column is random and i have data points at these
random distances.

I am trying to average the deflection values over distances of 20 metres or
so.
to end up with something like

distance deflection
0-20 5.67
20-40 24.3

etc.

any help would be great.
Thanks