Formula for calculating averages of values in two consecutive rows

[#1]

hi

 I would like to calculate averages of two consecutive values in separate rows and I have table with 1000 rows.  What formula can I use to do this?

Thanks 

[#2]

I think Col Moving Average should be able to do it Col Moving Average (jmp.com help) 

From scripting index:

[#3]

thanks for the quick response.  I used the formula below:

Col Moving Average( :raw_result, 1, 1, 0 )

96     96

93     94.5

100   96.5

110   105

How do i change the formula to get rid of the two underlined values?

Thanks again

[#4 · Accepted solution]

if(mod(row(),2)==0,
mean(:raw_result,lag(:raw_result)),
.
);

This will calculate the average for every even numbered row and a missing value for each odd numbered row.

[#5]

Thanks so much, this worked.  

[#6]

The previous posted option will work great. You might also consider the Lag() function within the Mean() formula to reference the previous row, so it would read something like the below:

Mean( :Column, Lag( :Column ) )

[#7]

Thanks, I will try this as well