Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr-...

Transcribed Image Text:

Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 1-Apr-04 1.8664 1.8260 1.7674 04 04 14-Apr- 26-Apr- 2-Apr-04 1.8393 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.8474 1.8104 1.7720 04 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8055 1.7851 04 04 20-Apr- 30-Apr- 8-Apr-04 1.8425 1.7914 1.7844 04 04 21-Apr- 9-Apr-04 1.8422 1.7720 3-Маy-04 1.7720 04 12-Apr- 22-Apr- 1.8458 1.7684 4-May-04 1.7607 04 04 13-Маy- 21-Мay- 5-May-04 1.7832 1.7584 1.7880 04 04 14-May- 24-Мay- 6-May-04 1.7841 1.7572 1.7908 04 04 17-Мaу- 25-Мay- 7-Mаy-04 1.7942 1.7595 1.8335 04 04 10-May- 18-May- 26-May- 1.7823 1.7795 1.8342 04 04 04 11-Маy- 19-Маy- 27-Мay- 1.7644 1.7827 1.8769 04 04 04 12-Маy- 20-May - 28-May- 1.7743 1.7710 1.8530 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 2 3 4 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 1-Apr-04 1.8664 1.8260 1.7674 04 04 14-Apr- 26-Apr- 2-Apr-04 1.8393 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.8474 1.8104 1.7720 04 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8055 1.7851 04 04 20-Apr- 30-Apr- 8-Apr-04 1.8425 1.7914 1.7844 04 04 21-Apr- 9-Apr-04 1.8422 1.7720 3-Маy-04 1.7720 04 12-Apr- 22-Apr- 1.8458 1.7684 4-May-04 1.7607 04 04 13-Маy- 21-Мay- 5-May-04 1.7832 1.7584 1.7880 04 04 14-May- 24-Мay- 6-May-04 1.7841 1.7572 1.7908 04 04 17-Мaу- 25-Мay- 7-Mаy-04 1.7942 1.7595 1.8335 04 04 10-May- 18-May- 26-May- 1.7823 1.7795 1.8342 04 04 04 11-Маy- 19-Маy- 27-Мay- 1.7644 1.7827 1.8769 04 04 04 12-Маy- 20-May - 28-May- 1.7743 1.7710 1.8530 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 2 3 4

Answer rating: 100% (QA)

Solution ar... View the full answer