cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
jojmp
jojmp
Level III

Moving Average

Created: Jan 3, 2019 07:56 AM  |  Last Modified: Jan 3, 2019 4:59 AM (19580 views)

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. 

Drugs.jmp
0 Kudos
12 REPLIES 12
txnelson
Super User txnelson
Super User

Re: Moving Average

Jan 3, 2019 08:56 AM (18080 views)  |  Posted in reply to message from jojmp 01-03-2019

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

Col Moving Average( :Result, weighting = 1, before = 3, :Drug )
Jim
jojmp
jojmp
Level III

Re: Moving Average

Jan 9, 2019 04:12 AM (1337 views)  |  Posted in reply to message from txnelson 01-03-2019
what does weighting = 1, before = 3, :Drug mean?
Could you please explain the formula
0 Kudos
PatrickGiuliano
Staff PatrickGiuliano
Staff

Re: Moving Average

Aug 9, 2022 09:13 PM (1002 views)  |  Posted in reply to message from jojmp 01-09-2019

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#

 

PatrickGiuliano_0-1660093800183.png

 

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:

 

 

Recommended Articles