topic Re: Moving Average in Discussions

Moving Average

jojmp — Thu, 03 Jan 2019 12:59:31 GMT

I have a table called drugs with columns drug and result, how do I calculate the moving average of the result column by taking the first 4 rows followed by the next 4 rows and similarly continue. Pfa the sample table for reference.

Re: Moving Average

gianpaolo — Thu, 03 Jan 2019 13:45:16 GMT

hello ,

you can try with Formula column --> row --> moving average

Re: Moving Average

txnelson — Thu, 03 Jan 2019 13:56:18 GMT

Create a new column in your data table, and apply the folloing formula

Col Moving Average( :Result, weighting = 1, before = 3, :Drug )

Re: Moving Average

jojmp — Fri, 04 Jan 2019 04:25:10 GMT

Could you please explain the next step after this, I want to calculate the average of 4 consecutive samples

Re: Moving Average

txnelson — Fri, 04 Jan 2019 04:35:56 GMT

Do you have 4 columns of results, or 4 times as many rows as you show in your sample data table?

Re: Moving Average

jojmp — Fri, 04 Jan 2019 04:43:48 GMT

I want to generate the moving average column as shown in the attached table, for every 4 rows I need to calculate the average

Re: Moving Average

txnelson — Fri, 04 Jan 2019 04:52:54 GMT

The formula to use is

If( Mod( Row(), 4 ) == 0,
	Mean( :Result[Index( Row() - 3, Row() )] )
)

I have attached your example data table, with a new column with the formula in it

Re: Moving Average

Phil_Kay — Fri, 04 Jan 2019 11:13:04 GMT

I think this will give you the moving average that you want (4 rows before and 4 rows after).

Re: Moving Average

jojmp — Wed, 09 Jan 2019 09:11:50 GMT

this did not work

Re: Moving Average

jojmp — Wed, 09 Jan 2019 09:12:38 GMT

what does weighting = 1, before = 3, :Drug mean?
Could you please explain the formula

Re: Moving Average

jojmp — Wed, 09 Jan 2019 09:13:18 GMT

Thanks this worked

Re: Moving Average

PatrickGiuliano — Wed, 10 Aug 2022 01:13:23 GMT

JMP's support documentation gives some additional background for how the formula may be defined (defines the arguments and also includes some nice little examples): https://www.jmp.com/support/help/en/16.2/#page/jmp/statistical-functions-2.shtml#

You can find in Wikipedia (https://en.wikipedia.org/wiki/Moving_average) more on first principles and mathematical/ conceptual understanding behind the Moving Average Calculation:

Re: Moving Average

markschahl — Wed, 23 Jul 2025 02:36:31 GMT

Thanks Jim!

Just used this method to calculate the difference between the maximum and minimum for the last n rows.

Hope you are doing well!