Skip to main content

Table of Contents

  1. Topic pack - Marketing - introduction
  2. 4.1 The role of marketing - notes
  3. 4.1 The role of marketing - questions
  4. 4.2 Marketing Planning - notes
    1. Marketing planning
    2. The marketing mix
    3. The Total Product Concept
    4. Ethics of marketing
    5. Marketing audit
    6. Porter's five forces
    7. Porter's five forces - activities
    8. Marketing objectives
    9. Market research - introduction
    10. The role of market research
    11. Primary and secondary research
    12. Primary research - information gathering techniques
    13. Observations - case studies
    14. Group-based market research
    15. Market research - summary
    16. Questionnaires
    17. Sampling
    18. Methods of sampling - introduction
    19. Main methods of sampling
    20. Sampling errors
    21. Market segmentation
    22. Consumer Profiles
    23. Types of segments
    24. Demographic segmentation
    25. Psychographic segmentation
    26. Psychographic segmentation - case study
    27. Geographic segmentation
    28. Industrial markets
    29. Targeting
    30. Positioning
    31. Corporate image
    32. Position/perception maps
    33. Unique selling point/proposition USP
    34. Marketing strategies and tactics
    35. Sales forecasting
    36. Qualitative forecasting/data
    37. Forecasting and correlation
    38. Forecasting techniques
    39. Constructing time-series analysis
    40. Moving average
    41. Four point moving average - worked example
    42. Identifying the seasonal variation
  5. 4.2 Marketing planning - questions
  6. 4.3 Product introduction - notes
  7. 4.3 Product - questions
  8. 4.3 Product - simulations and activities
  9. 4.4 Price - notes
  10. 4.4 Price - questions
  11. 4.4 Price - simulations and activities
  12. 4.4 Promotion - notes
  13. 4.5 Promotion - questions
  14. 4.6 Place (distribution) - notes
  15. 4.7 International marketing - notes
  16. 4.7 International marketing - questions
  17. 4.8 E-commerce - notes
  18. 4.8 E-commerce - questions
  19. Printable version

Moving average

The nature of the latest business and management programme and the nature of the papers means that this has proved a less popular question than in earlier programmes as the calculations can be quite time consuming leaving little time to analyse or evaluate.

A moving average is used to 'smooth' the data and remove the variations produced by seasons, trade cycles and random variations. There are a number of moving averages that can be used, with the following being the most common.

  • Three-point average
  • Four-point moving average.

Three-point moving average:

This is by far the easiest and quickest moving average to calculate, but it does not completely smooth the trend line and so makes accurate extrapolation more difficult.

Three-point averages are calculated by taking a number in the series with the previous and next numbers and averaging the three of them.

\\10.10.9.2\file server\TripleA\Design\icons\small\eg.gif

Series:
Actual sales
2080
1200
1520
2560
2160
2000


The underlying trend in the series above is not clear because of the variations within the data. If we calculate a moving average, however, we are able to remove some of these variations.


\\10.10.9.2\file server\TripleA\Design\icons\small\nb.gif

For any series of numbers you are able to calculate 2 less three-point moving averages than there are numbers in the series because:

  • the first number does not have a previous number
  • the last number does not have a next number


Moving Average (1): take the first three figures in the series and average them:

Moving Average (2): drop the first figure from the front and add in the next in the series

Moving Average (3): continue to use the next set of three figures in the series

Moving Average (4): continue to use the next set of three figures in the series

So from a set of six sales figures, we have produced 4 three point moving average calculations:

1600
1760
2080
2240

From these results the trend has become obvious - it shows that the trend is positive and there is sales growth.

Three point moving averages are also useful in working out the average variations across a longer period. This is because the average of three numbers falls on the middle of the series and so can be compared directly with the actual sales for that period

Series:

Actual sales

Trend (3-point)

Sales

Variation

Sales - Trend

2080
1200 1600 -400
1520 1760 -240
2560 2080 +480
2160 2240 -80
2000


If these variations are seasonal or cyclical they can be used to predict actual sales by adjusting the extrapolated future sales to take account of the predictable variation. In the example above we can see that the trend sales are NEVER equal to the actual sales and so could not be used to plan future production for instance without further analysis. The trend on its own can only be used to show whether future sales are likely to be higher or lower than past sales.

Four-point moving average:

A four-point moving average will smooth out the trend line more effectively than a three-point moving average, but has the following problems which make calculations more difficult:

  • There are fewer moving average results
  • The average of four figures falls on the mid-point which does not correspond to an actual sales figure - an example is given later. This requires a further adjustment to be made to allow direct comparisons to be made.

However, a four point moving average does correspond with how sales are often reported which is quarterly - i.e. every three months.

Series:

Actual sales

2080
1200
1520
2560
2160
2000


The underlying trend in the data is not clear because of the variations within the data. If we calculate a moving average we are able to remove some of these variations.

\\10.10.9.2\file server\TripleA\Design\icons\small\nb.gif

For any series of numbers you are able to calculate 3 less four point moving averages than there are numbers in the series

Moving Average (1): take the first four figures in the series:

Moving Average (2): drop the first figure from the front and add in the next in the series

Moving Average (3): continue to use the next set of three figures in the series

For a moving average based on an odd number, the midpoint coincides with one of the original sales values. For a moving average based on an even number it does not:

Mean of three-point average

S:\TripleA\DP_topic_packs\business management\student_packs\media_marketing\images\moving_average_1.gif

The average falls on the mid-point of the series which is the second sales figures, so it can be compared directly with the actual sales, showing the trend sales are 400 higher than actual sales.

Mean of four-quarter average

S:\TripleA\DP_topic_packs\business management\student_packs\media_marketing\images\moving_average_2.gif

The trend average falls between 2 and 3 in the series and cannot be directly compared with either the actual sales for period 2 or period 3

So with a four-point moving average we only produce three results from our series, and these do not correspond with actual sales and so no variation can be established:

1840
1860
2060

Series:

Actual sales

Trend (4-point)

Sales

2080
1200
1840
1520
1860
2560
2060
2160
2000


So how can a variation be established?

Well statisticians use a method called Centreing. This means averaging two averages to produce a result which does correspond with an actual sales figure.

In our very small series we would do this by averaging 1840 + 1860 and 1860 + 2060:

The resulting figures now correspond to an actual sales figure and so a variation can now be established.

Series:

Actual sales

Trend (4-point)

Sales

Centred trends

Variation

Sales - Trend

2080
1200
1840
1520 1850 - 330
1860
2560 1960 + 600
2060
2160
2000


By averaging (centreing) two four-point moving averages we have managed to produce results that can be compared, but only TWO of them. It must be clear that this method is not very suitable with only a small series of results. However, follow the example below to see how it can work with a larger series of figures, related to quarterly sales.