What's in this article?
- Learn how to use the Moving Average (Exponential) function
- Step-by-step instructions
- Example of scenarios where the Moving Average function is useful
How to use the Moving Average (Exponential) function
Moving Average (Exponential) returns the moving average of the previous
n data points for each of the given
values. This function is used to smooth out data sets to help clarify trends. For example, if you had a Google Analytics data source that showed website visitors with a significant decrease each weekend, the Moving Average function will help provide a more consistent representation of the data.
What's the difference?
Moving Average Exponential puts more weight on values occurring more recently in the data set.
To use the Moving Average (Simple) function
Note: These procedures assume you are in the Klip Editor.
- Select a component from the Component Tree.
- Click the Start Formula link in the formula editor.
- Click the Insert Function button on the formula editing toolbar.
- Select the
MA_EXPONENTIALfrom the Statistics category in the Function's menu.
- Click the
- Select a range of values from the data source.
- Click the
- Supply a value for n.
To better understand how the moving average (simple) function works, consider this basic example.
MA_EXPONENTIAL (7, 6, 3, 9, 5, 10, 2, 8, 1, 4) , 19)
The result would be as follows:
(7, 6.9, 6.51, 6.76, 6.58, 6.92, 6.43, 6.59, 6.03, 5.83)
Bar / Line Chart
The Moving Average (Exponential) function is often used in a bar or line chart to smooth out data sets. Here is an example that shows the raw data (the red line) compared to data manipulated using the Moving Average (Exponential) function (the blue line) where
n equals 5.