The following table shows the number of items of certain product imported into the United Kingdom is given below in thousands of units for the Years
Years 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964
Consumption 170 210 188 98 83 131 205 182 90 92
(Thousands of bales).
i) 5-years moving total
ii) 5-years moving average.
All calculations should be in Excel.
Excel automatically compiles these results for you by graphing it. However, please note that a simple moving average (SMA) is the unweighted mean of the previous n data points. Therefore, you calculate the mean of the last five years of data for each point. Likewise, you sum the values of the last five years for the moving total.
Originally Posted by cu4mail
I would have put the five year moving avaerage for year tobe:
Originally Posted by colby2152
that is I would always prefer the central moving average.
(of course Excel just gives the rolling MA)
It depends where it is centered around. Simple moving averages look at past data, because that data is given and known. You cannot use unknown values in the future for a moving average.
Originally Posted by CaptainBlack