nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

rolling moving average

Sebnem

Hi,

I want to create a new column "moving average" and want this column to do rolling average of temp based on ID. I attached a sample file here. Can you please help with the formula?

thanks!

moving average based on ID grouping.jmp

Accepted answers

All comments

txnelson

Assuming that your definition of "Rolling Average" is a "Moving Average" the formula is

Col Moving Average( :Temp, :ID )

Documentation and Examples of the Col Moving Average() are in the Scripting Index

Help==>Scripting Index

Sebnem

Hi Jim

I used this formula but this does not deliver what I was expecting.

First: I want to create column which is the mean of temp by ID

Then, I want to mean of the new column over "X (X is user defined)" number of IDs.

Can you please help with that?

moving average based on ID grouping.jmp

txnelson

If you read the documentation on the Col Moving Average() function, it allows for the setting of what I believe you are referring to as X.

Could you please provide some sample results. I am still not understanding your request.

Sebnem

I looked into big class sample data set and created a column:

Col Moving Average( :height, 1, 5, 0, :sex )

What does 5 do in the calculation?

I was able to manually calculate the moving average until the row#9---How was 58.833333333 calculated? I am not able to generate the same number manually

Big Class_SK.jmp