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

Formula for calculating averages of values in two consecutive rows

VR — Sat, 10 Jun 2023 23:45:27 GMT

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

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

jthi — Thu, 10 Mar 2022 16:34:23 GMT

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

From scripting index:

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

Joseph_Reese — Thu, 10 Mar 2022 16:40:49 GMT

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

VR — Thu, 10 Mar 2022 18:30:58 GMT

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

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

VR — Thu, 10 Mar 2022 18:31:36 GMT

Thanks, I will try this as well

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

txnelson — Thu, 10 Mar 2022 19:04:49 GMT

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.

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

VR — Thu, 10 Mar 2022 19:09:37 GMT

Thanks so much, this worked.