- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Moving Average
I have a data set of >300 rows. I want to create a column that has the moving average of the previous 20 rows of the Results column.
I want my new moving average column will look like this
rows 1 to 20 will be blank,
row 21 will have the average result of rows 1-20 of the Results column,
row 22 will have average results of rows 2-21 of the Results column,
row 23 will have average results of rows 2-22 of the Results column
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Moving Average
You should double-check that this gives the correct numbers but I think this is the sequence:
1. Right click on the column and select New Formula Column
2. Select Row> Moving Average
3. For Weight, specify 'Equal'
4. For Items Before, specify 'Fixed', and enter a value of 20
5. Select 'report missing values for partial window'
6. Click OK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Moving Average
You should double-check that this gives the correct numbers but I think this is the sequence:
1. Right click on the column and select New Formula Column
2. Select Row> Moving Average
3. For Weight, specify 'Equal'
4. For Items Before, specify 'Fixed', and enter a value of 20
5. Select 'report missing values for partial window'
6. Click OK