Gloria began her work by consulting the company's information system from which she pulled data on...

Transcribed Image Text:

Gloria began her work by consulting the company's information system from which she pulled data on sales volumes from a few previous years. This data is necessary to make a forecast for the following year. The data below represents sales made by the SME in 15 previous quarters (from 1 to 15; quarter 16 represents the next quarter). t123456 7 8 9 10 11 12 13 14 15 Y(t) 2601 2531 2640 2747 2803 2699 2628 2741 2849 2902 2797 2732 2839 2951 2996 1. Represent this chronicle graphically. Since the chronicle is periodic and it has base 5, represent the corresponding series of centered moving averages on the previous graph. 2 We choose an additive model. Calculate seasonal coefficients. Calculate the seasonally adjusted series (CVS series) and plot it on the previous graph. Fit the CVS series with a line using the least squares method. Represent this line on the 3 previous graph. 4 Give the forecasts for the next four quarters: 16, 17, 18 and 19. 5 Gloria began her work by consulting the company's information system from which she pulled data on sales volumes from a few previous years. This data is necessary to make a forecast for the following year. The data below represents sales made by the SME in 15 previous quarters (from 1 to 15; quarter 16 represents the next quarter). t123456 7 8 9 10 11 12 13 14 15 Y(t) 2601 2531 2640 2747 2803 2699 2628 2741 2849 2902 2797 2732 2839 2951 2996 1. Represent this chronicle graphically. Since the chronicle is periodic and it has base 5, represent the corresponding series of centered moving averages on the previous graph. 2 We choose an additive model. Calculate seasonal coefficients. Calculate the seasonally adjusted series (CVS series) and plot it on the previous graph. Fit the CVS series with a line using the least squares method. Represent this line on the 3 previous graph. 4 Give the forecasts for the next four quarters: 16, 17, 18 and 19. 5