9 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rote Date Rate Date Rate 1-Apr-04 1. 8564 13-Apr -04 1. 8160 23-Apr-04 1.7674 2 2-Apr-84 1. 8293 14-Apr-84 1. 7902 26-Apr-04 1.7857 points. 5-Apr-04 1. 8140 6-Apr-84 15-Apr-B4 1.7785 1. 8374 16-Apr-84 27-Apr-04 1.7925 1. 8084 7-Apri-84 28-Apr-04 1.7720 1. 8410 Skipped 19-Apr-84 1.8055 29-Apr-04 1.7751 8-Apr-84 1. 8325 20-Apr-04 1.7914 9-Apr-84 30-Apr-64 1.7744 1.8322 21-Apr-84 1. 7720 12-Apr -04 22-Apr-84 3-May-04 1.7720 1. 8358 5-May-84 1. 7684 13-May-84 4-May-84 1.7907 6-May-84 1.7932 1.7584 1.7941 21-May-04 1.7880 -Book 7-May-84 14-May-04 1.7908 1.7842 17-May-04 1.7572 24-May-04 1.7695 25-May-04 1.8135 10-May-04 11-May -04 1.7723 1.7544 18-May-84 19-May-04 1.7695 26-May-04 1.8142 1.7827 12-May-04 27-May-84 1.8369 1.7743 20-May -84 1.7719 28-May-04 1.8330 References 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 (b) Which value of m do you prefer? The preferred mvalue Is [(Click to select) v . This value of m Using this allows one to forecast the weekly or monthly trends (Click to select) v ]overreacting to daily fluctuations. c) Is a moving average appropriate for this kind of data? (Click to select) v . a moving average is [(Click to select) V