Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 1-Apr-04 1.8564 1.8160 1.7674 04 04 14-Apr- 26-Apr- 2-Apr-04 1.8293 1.7902 1.7857 04 04 15-Apr- 27-Apr- 5-Apr-04 1.8140 1.7785 1.7925 04 04 16-Apr- 28-Apr- 6-Apr-04 1.8374 1.8004 1.7720 04 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8055 1.7751 04 04 20-Apr- 30-pr- 8-Apr-04 1.8325 1.7914 1.7744 04 04 21-Apr- 9-Apr-04 1.8322 1.7720 3-ay-04 1.7720 04 12-Apr- 22-Apr- 1.8358 1.7684 4-May-04 1.7907 04 04 13-ay- 21-ay- 5-ay-04 1.7932 1.7584 1.7880 04 04 14-May- 24-- 6-ay-04 1.7941 1.7572 1.7908 04 04 17-May- 25-ay- 7-ay-04 1.7842 1.7695 1.8135 04 04 10-May- 18-May- 26-May- 1.7723 1.7695 1.8142 04 04 04 11-ay- 19-May- 27-May- 1.7544 1.7827 1.8369 04 04 04 12-May- 20-May- 28-ay- 1.7743 1.7710 1.8330 04 04 04 Click here for the Excel Data File (a) Make a line chart and fit an m-period moving average to the exchange rate data shown above with m= 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.) m-period Next period forecast