The first aspect of this field worth mentioning is that the range is quite wide. With 10 different entries, it would be quite impossible to anticipate the next entry in this field, because it varies so much. However, if you follow a moving average, you will gain a less volatile view of what is occurring in this trend. To compute a moving average, add up the values and then divide by the number of values.

Formula: Simple Moving Average


N = numerical; values in the field T = total number of values A = simple moving average

A simple moving average of the five most recent fields would show how averaging smoothes out even the most volatile trend:


0 0

Post a comment