The yield on a general obligation bond for the city of Stafford fluctuates with the market. The monthly quotations for 2020 are given, a Find the forecast value of the yield on the obligation bonds for each month starting with April, by using a 3-month moving average b. Find the forecast value of the yield on the obligation bonds for each month starting with June, by using a 5-month moving average. Use Excel for this problem, copy and paste your answer

Municipal Bond Yield Month Yield

month yield

Jan. 9.33

Feb. 10.03

mar. 10.2

apr. 10.29

may. 10.65

June. 11.11

July. 11.56

Aug. 11.13

sep. 10.84

oct. 10.54

Nov. 10.9

Dec. 10.01

The yield on a good tistio bond for the city of Stafford fluctuates with the market. The many stations for 2020 are given, a Find the forecast value of the old on the goods for each month starting with April, by using a 3 month moving average . Find the forecast value of the yield on the obligation bonds for each month Set with me, by using a mom moving average Use Excel for this problem, by and paste your wor 40 points SOVER Municipal Bond Yield Month Yield 9,13 Feb 10.03 Mar 10.2 Apr 10.25 May 10.55 June 11.11 July 1163 Aus 11.13 Sep 10.84 Oct 10:56 Nov 10.9 Dec 10.01 For the toolbar.press ALT.10 IPC or ALTIN F1 Mac B TV5 Paragraph Aris 10pt !!! E A 2 I. XOOQ 50