I was wondering if you could assist me in setting up a moving average for some data points that I have in excel.

age d18O
0.00 3.11
0.00 2.88
0.02 3.41
0.05 3.17
0.09 3.27
0.12 3.32
0.27 3.03
0.36 3.31
0.49 3.14
0.50 3.75
0.60 3.42
0.83 3.03
0.84 3.47
0.91 3.04
0.92 2.91
0.98 3.64
0.99 3.44

I have values like these all the way to about 5300, and I would like to get an average d18O value for all the values between 0.00-0.99. I have used this formula: =AVERAGEIFS(B:B,A:A,">=0.0",A:A,"<=0.99"). But, I have no idea how to make excel continue to follow through the series (take an average from 1-1.99, 2-2.99….) without typing it in manually.



Please let me know if you can help me figure this out.

Justin

Just take an average of the top however many you want (5,10,100,1 million) and just copy it down.

Attach your file and maybe someone can help you.

I should mention as well that if you chart the data you can add a moving average trendline.

To be more clear, enter the following equation and copy it down.

=AVERAGE(C2:C18)