Moving Average is located under Forecasting () in Modeling, on the left task pane. Use the drag-and-drop method to use the algorithm on the canvas. Click the algorithm to view and select different properties for analysis.
Refer to the Properties of Moving Average.
Consider a time-series data containing the following annual sales figures. We calculate the Moving Average over three years, for years 2015-2016-2017, 2016-2017-2018, and 2017-2018-2019. These values are given in the table below.
Year | Sales (In Millions) | Moving Average (Three Year Average) |
2015 | 5.0 | NA |
2016 | 5.4 | NA |
2017 | 5.7 | (5.0 + 5.4 + 5.7) / 3 = 5.366 |
2018 | 6.1 | (5.4 + 5.7 + 6.1) / 3 = 5.733 |
2019 | 6.4 | (5.7 + 6.1 + 6.4) / 3= 6.066 |
The available properties of Moving Average are as shown in the figure below.
The table below describes the different fields present on the properties of Moving Average.
Field | Description | Remark | |
Run | It allows you to run the node. | - | |
Explore | It allows you to explore the successfully executed node. | - | |
Vertical Ellipses | The available options are
| - | |
Task Name | It is the name of the task selected on the workbook canvas. |
| |
Time ID Variable | It allows you to select the time variable. | The dataset should contain at least one time variable. | |
Target Variable | It allows you to select the variable for performing the moving Average. | The variable selected can be discrete or continuous. | |
Group By | It allows you to select the function for grouping identical data. |
| |
Advanced | Re-train | It allows you to select whether you want to re-train the moving average model. |
|
Interval | It allows you to select the interval on which you want to calculate the Moving Average. |
| |
Number of Periods for Forecasting | It allows you to select a specific number of periods you want to forecast based on the moving average results. |
| |
Confidence Level (%) | It allows you to select the confidence level with which we predict the results. |
| |
Window Size | It allows you to select the number of data points you want to select for calculating the Average. |
| |
Node Configuration | It allows you to select the instance of the Amazon Web Services (AWS) server to provide control on the execution of a task in a workbook or workflow. | For more details, refer to the Worker Node Configuration. |
Consider a FemaleBirthData dataset with 365 records. It contains columns for Date, Number of Daily Births, and the corresponding Quarters. A snippet of the input data is shown in the figure given below.
We apply Moving Average on the input data. The selected values for Moving Average are given below.
Property | Value |
Time ID Variable | Date |
Target Variable | Births |
Group By | Quarter |
Retrain | Yes |
Interval | Day |
Number of Periods for Forecasting | 5 |
Confidence Level (%) | 95 |
Window Size | 4 |
On the Data pane, you see the predicted values for the corresponding data points in the output. As you can see,
Further, the Result page displays
Similarly, you can change the Quarter from the Select Group field and obtain the corresponding plots.