User Community
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: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 (24099 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 (19030 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 (2287 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 (1952 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