U.S. / U.K. Foreign Exchange Rate, U.S. Dollars to One British Pound (n = 60 days)

DateRate

1-Nov1.2950

4-Nov1.2906

5-Nov1.2870

6-Nov1.2872

7-Nov1.2829

8-Nov1.2790

12-Nov1.2855

13-Nov1.2840

14-Nov1.2879

15-Nov1.2901

18-Nov1.2965

19-Nov1.2926

20-Nov1.2918

21-Nov1.2915

22-Nov1.2829

25-Nov1.2885

26-Nov1.2850

27-Nov1.2881

29-Nov1.2939

2-Dec1.2936

3-Dec1.3002

4-Dec1.3095

5-Dec1.3165

6-Dec1.3127

9-Dec1.3157

10-Dec1.3178

11-Dec1.3176

12-Dec1.3133

13-Dec1.3349

16-Dec1.3330

17-Dec1.3116

18-Dec1.3078

19-Dec1.3034

20-Dec1.3036

23-Dec1.2917

24-Dec1.2955

26-Dec1.3007

27-Dec1.3090

30-Dec1.3140

31-Dec1.3269

2-Jan1.3128

3-Jan1.3091

6-Jan1.3163

7-Jan1.3127

8-Jan1.3110

9-Jan1.3069

10-Jan1.3060

13-Jan1.2983

14-Jan1.3018

15-Jan1.3030

16-Jan1.3076

17-Jan1.3029

21-Jan1.3047

22-Jan1.3136

23-Jan1.3104

24-Jan1.3071

27-Jan1.3054

28-Jan1.2996

29-Jan1.3012

30-Jan1.3106

Click here for the Excel Data File (a) Make a line chart for an m-period moving average to the exchange rate data shown below with m=2,3,4, and 5 periods. For each method, state the last MA value. (Round your answer to 4 decimal places.) Click here for the Excel Data File (a) Make a line chart for an m-period moving average to the exchange rate data shown below with m=2,3,4, and 5 periods. For each method, state the last MA value. (Round your answer to 4 decimal places.)