Please answer A

Carl Wright, Inc. specializes in direct mail coupon advertising for major food manufacturers. One client has run 10 advertising campaigns weekly using this medium. The response rate for cupouns for the lastg 10 campaigns which were taken consecutively over the last 10 weeks are as follows Campaign Response % 1 4.6 2 5.2 3 4.8 4 5.3 5 4.5 6 5.9 7 5.2 8 5.4 9 4.7 10 4.9 a. Which model will provide more accurate forecasts of the response rate for future advertising campaigns: (1) 2-period Moving average (2) 6-period moving average. To answer do the following: (i) Apply MAE using the template. (ii) Demonstrate the MAE calculation of the 6-period moving on the given time series b. Use the better model of part 'a' to forecast the response rate for the next 2 weekly campaigns. Show your work. c. Use Exponential Smoothing as follows: (i) with Data Table determine the best alpha value based on MAE. Let alpha change in increments of 0.05. (ii) Demonstrate the application of exponential smoothing using the alpha value you found above, for the first four periods only. (that is, show your calculations for the first 4 periods by applying the exponential smoothing method). d. Use WMA of 3-periods, with W1 = 0.7, W2 = 0.2, and W3 = 0.1 to make the same forecasts as in question 'b'. Question a (0) From the template conclude that the better model is the period moving average (ii) Here how I calculate MAE for the 6-period moving average aaplied to this time series Question b Using the better model from question 'a', here are the required forecasts F( ) = FO ) = Question c (i) The best alpha I found is (i) Here I demonstrate the application of the exponential smoothing for the first 4 [periods only: F(2) = F(3) = etc Question d