MA_EXPONENTIAL function

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.

  1. Select a component from the Component Tree.
  2. Select the MA_EXPONENTIAL function.
  3. Select a range of values from the data source.
  4. Supply a value for n.

Examples

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.