Using Exel

Question 2: A High Street chemist sells travel first aid packs. The numbers of these sold over three years were: Quarter Quarter 2 Quarter Quarter 1 3 4 Year 1 11 37 61 18 Year 2 13 49 58 16 16 53 66 18 Year 3 a. Construct a time series chart; plot the dots according to time and connect them with lines. b. Calculate four-point centered moving averages for the series and plot them on the chart. c. Applying the Multiplicative decomposition model, identify the seasonal component for each quarter. d. Calculate the mean squared deviation (MSD) for model. e. Using Multiplicative decomposition modal generate forecast for year 4