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: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

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 (23444 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 (18860 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 (2117 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 (1782 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