turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Moving average calculation in JMP 6

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Feb 4, 2009 11:57 AM
(1430 views)

Hi There,

Is there a way for me to calculate the moving average in JMP 6?

Thanks,

Is there a way for me to calculate the moving average in JMP 6?

Thanks,

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Feb 5, 2009 7:23 AM
(1155 views)

I think you can do it using the statistical "summation" function and row functions. Here's an example for a 4-point moving average:

If(Row() < 4, Empty(), Summation(i = Row() - 3, Row(), :Column 1[i,Empty()]) / 4)

I used the "If" function to avoid errors when ( Row()-3 ) is less than 1. I'd be interested to see if someone else has a simpler way to do this.

If(Row() < 4, Empty(), Summation(i = Row() - 3, Row(), :Column 1[i,Empty()]) / 4)

I used the "If" function to avoid errors when ( Row()-3 ) is less than 1. I'd be interested to see if someone else has a simpler way to do this.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Nov 4, 2011 2:51 AM
(1155 views)

Hi BillHallet,

I wonder if i should have a table with 1 column more that 4 row. Then run this JSL to get 4-point moving average? Then the result will be added into the following row?

Thanks a lot,Kun