please help

vas XC 6 2 7 Question 6 8 pts The company Jackoman Groove has sales ($10,000) shown in the following table. The data below covers the period from Oct 2019 until Apr 2020 a) Use 5 period moving averages to predict the sales for the time periods (6-9) and fill in the table below b) De-seasonalize the forecast for period 9 using seasonal index 0.9 Round off your answers to one decimal place b) Calculate the errors and fill in the table below. Only write the number value (ignore + and -) c) Calculate the error and fill in the table below. d) Calculate MAD Round off your answers to one decimal place. e)Calculate MSE Round off your answers to one decimal place. f) The other purpose of the moving averages is to a time series g) The prediction for which time period has the least error ? type only the number h) If the MAD for 4-MA is 3, which model is better 4 or 5 2 Time Sales($) 5-Moving ABS(Errors) Errors? Period averages 1 26 N/A 2 33 N/A 13 39 NIA /1 F3 End F4 PrtScn F7 Home FB F6 F5 59 ! @ # $ % A & 1 2 3 4 5 6 7 8 9 o W R XCO Time Sales($) 5-Moving ABS(Errors) Errors? Period averages 1 26 N/A 2 33 N/A 3 39 4 34 N/A ch 38 N/A 16 41 43 8 34 19 EX 16 F1 F2 F3 Home F4 F5 PrtScn F7 F6 F8 a # $ % A &