(a) Use Excel, MegaStat, or MINITAB to t an m-period moving average to the exchange rate data shown below with m = 2, 3, 4, and 5 periods. Make a line chart.
(b) Which value of m do you prefer? Why?
(c) Is a moving average appropriate for this kind of data? Include a chart for each value of m.

Transcribed Image Text:

Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 2-Apr04 8564 3-Apr-0418160 23-Apr-04 1.7674 14-Apr-04 15-Apr-04 8293 1.8293 4Apr-04 SAp04 40Apr04 17785 27-Apr-04 1.7925 6-Apr0418374 16Apr-04 18004 8pr-04 1.7720 7-Apr04 84 19-Apr-04 18055 29-Apr-04 1.7751 7902 26Ap041.7857 i7751 44 1.7785 28-Apr-04 1.8004 29-Apr-04 1.8325 20-Apr-04 1.7914 30-Apr-04 1.7744 9-Apr04 8322 21-Apr-04 1.7720 3-May-04 1.7720 12-Apr04 8358 22-Apr04 .764 4May-04 1.7907 1.8358 A04 1.7914 2904 Date Rate Date Rate Date Rate 5-May-04 1.7932 3-May-04 1.7584 21-May-04 1.7880 6-May-04 .794 14-May-04 1.7572 24-May-04 1.7908 7-May-04 1.7842 17-May-04 7695 25-May-04 18135 10-May-04 1.7723 18-May-04 76 26-May-04 1.8142 1May-04 .7544 9-ay-04 .727 27-May-04 18369 12-May-04 1.7743 20-May-04 7710 28-May-04 1.8330