Question: could you please solve it with following the same order of points a) b) c) d) e) Question 2: A High Street chemist sells travel
could you please solve it with following the same order of points a) b) c) d) e) Question 2: A High Street chemist sells travel first aid packs. The numbers of these sold over three years were: Quarter 2 Quarter Quarter Quarter 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. could you please solve it with following the same order of points a) b) c) d) e) Question 2: A High Street chemist sells travel first aid packs. The numbers of these sold over three years were: Quarter 2 Quarter Quarter Quarter 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
