use excel data to answer questions

What is the 5-month moving average forecast for Oct of Year 17 Round to one decimal point poocx) What is the weighted moving average forecast for August of Year 2 using weights of 1 foldest) 2.4 and 8 (newest)? Round to one decimal point ox) What is the exponential smoothing forecast for March of Year 2 using pha of 02? Begin forecasting the first month possible, and then continue your forecast to this point. Round to one decimal point ox) What are the forecasts for January of Year 3 using the following forecast methods. Round to one decimal point (0X0. - 5 month weighted average -weighted moving average forecast using weights of 1 Coldest). 2.4 and 8 newest) exponential smoothing forecast using alpha oto2 What are the MSE values for the data? Round to one decimal point (6000 and do not include commas. - 5 month moving average -weighted moving average forecast using weights of 1 (oldest, 2, 4, and 8 (newest exponential smoothing forecast using alpha of 02 (do not include January of Yeart in your calculation) Which of these forecasts has been the most accurate according to the past results? B D E F G 1 Year 2 Year 1 3 C Devices Sold 530 517 538 562 3 4 5 6 7 8 9 10 11 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 12 13 14 Year 2 15 16 17 18 19 20 21 22 23 24 1 488 541 589 500 538 540 562 498 575 519 504 534 610 558 531 503 554 518 511 521 2 2 2 2 2 25 Dec 26 27