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

1955-64.

Years 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964

Consumption 170 210 188 98 83 131 205 182 90 92

of Cotton

(Thousands of bales).

Calculate

i) 5-years moving total

ii) 5-years moving average.

All calculations should be in Excel.

Thanks