Nov 2018 Q6
a) State the TWO (2) main models of time series analysis. (2 marks)
View Solution
A series of values of a quantity obtained at successive times, often with equal intervals between them.
The two main models of time series analysis are;
- the multiplicative model and
- the additive model.
b) Membership of Pro Amalion, a network of professional volunteers, has grown over the years but in the months of the second quarter there was always a decline. The table below shows membership records for a period of four years:
Required:
i) Calculate the centred four-quarterly moving average of membership. (4 marks)
View Solution
ii) Using a least squares trend equation base on (i) above, calculate the trend values. (5 marks)
View Solution
iii) Using (ii) above, calculate the percentage seasonal variation and the average seasonal variation of membership. (5 marks)
View Solution
Adjustment factor of 0.00125 (4-3.995=0.005 and 0.005/4=0.00125) must be added to each average to make the total average 4. Since this is insignificant, the difference of 0.005 is arbitrarily added to the average of Quarter 2.
iv) Determine the seasonally adjusted forecast of membership for each of the four quarters of Year 5. (4 marks)
View Solution
The forecasted membership: Quarter 1 is 845 members, Quarter 2 is 818 members;
Quarter 3 is 855 members and Quarter 4 is 872 members.