Please do A-G I have no idea how to do this problem. Please explain all the excel functions being used so I can follow along. The more explanations the better really want to learn the material. Thank you so much

Problem 2 (15 points) The yield on a general obligation bond for the city of Davenport fluctuates with the market. The monthly quotations for 2019 are given in Table below. a. Find the forecast value of the yield for the obligation bonds for each month, starting with May, using a four-month moving average. b. Find the forecast value of the yield for the obligation bonds for each month, starting with July, using a six-month moving average. c. Evaluate these forecasting methods using the MAD. d. Evaluate these forecasting methods using the RMSE. e. Evaluate these forecasting methods using the MAPE. f. Forecast the yield for January 2020 using the better technique. g. Use exponential smoothing with a smoothing constant of 0.2 and an initial forecast of 9.29 for January 2019 to forecast the yield for January 2020. Is this forecast better than the forecast made using the better moving average model? Explain. Month Yield January 9.29 February 9.99 March 10.16 April 10.25 May 10.61 June 11.07 July 11.52 August 11.09 September 10.80 October 10.50 November 10.86 December 9.97