Simple Moving Averages

In a Simple Moving Average calculation, the original range of data values is split into smaller "windows" and a simple mean value of each window is calculated. An example of the calculation involved for such Simple Moving Averages is shown below.

Image show values used for Simple Moving Averages.

If the first three Sales values were summed and then this sum was divided by 3 to give a mean value, this value would be:

(10 + 15 + 17) / 3 = 42 / 3 = 14

Next, consider the mean of the sum of the second, third and fourth original values i.e.:

(15 + 17 + 20) / 3 = 52 / 3 = 17.33

This pattern could be repeated to reveal the mean values of the third, fourth and fifth values; fifth, sixth and seventh values and so on until all subsequent windows of three numbers are summed and their mean values obtained.

The Simple Moving Averages of the original range of values for a window of 3 (i.e. in this case, a 3-Month Simple Moving Average) could be evaluated to be:

Table 174. Simple Moving Average 

Month

Original Sales Values

3-Month Simple Moving Average

Jan

10

 

Feb

15

 

Mar

17

14

Apr

20

17.33

May

22

19.66

Jun

20

20.66

Jul

25

22.33

Aug

27

24

Sep

30

27.33

Oct

35

30.66

Nov

37

34

Dec

40

37.33