cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Moving Average

jojmp
jojmp
Level III
Created: Jan 3, 2019 07:56 AM  |  Last Modified: Jan 3, 2019 4:59 AM 17826 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
11 REPLIES 11
jojmp
jojmp
Level III


Re: Moving Average

Jan 9, 2019 04:12 AM (1081 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 (746 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