468424_en-US

liliconcom

Formula for calculating averages of values in two consecutive rows

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 

Advanced Statistical ModelingMass CustomizationRe: Formula for calculating averages of values in two consecutive rows

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 ) )

 

 

Re: Formula for calculating averages of values in two consecutive rows

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