Make an Excel line graph of the exchange rate data. Describe the pattern ...

     (a) Make   an Excel line graph of the exchange rate data. Describe the pattern. (b)   Click on the data and choose Add Trendline > Moving Average. Describe the   effect of increasing m (e.g., m = 2, 4, 6, etc.). Include a copy of each   graph with your answer. (c) Discuss how this moving average might help a   currency speculator.     

     Date Rate   03-Jan 1.3476   04-Jan 1.3295   05-Jan 1.3292   06-Jan 1.3187   07-Jan 1.3062   10-Jan 1.3109   11-Jan 1.3161   12-Jan 1.3281   13-Jan 1.3207   14-Jan 1.3106   17-Jan 1.3075   18-Jan 1.3043   19-Jan 1.3036   20-Jan 1.2959   21-Jan 1.3049   24-Jan 1.3041   25-Jan 1.2954   26-Jan 1.3081   27-Jan 1.3032   28-Jan 1.3033   31-Jan 1.3049   01-Feb 1.3017   02-Feb 1.3015   03-Feb 1.2959   04-Feb 1.2927   07-Feb 1.2773   08-Feb 1.2783   09-Feb 1.2797   10-Feb 1.2882   11-Feb 1.2864   14-Feb 1.2981   15-Feb 1.2986   16-Feb 1.2994   17-Feb 1.3083   18-Feb 1.3075   21-Feb 1.3153   22-Feb 1.323   23-Feb 1.3208   24-Feb 1.3205   25-Feb 1.3195   28-Feb 1.3274   01-Mar 1.3189   02-Mar 1.3127   03-Mar 1.313   04-Mar 1.3244   07-Mar 1.3203   08-Mar 1.3342   09-Mar 1.3384   10-Mar 1.3409   11-Mar 1.3465   14-Mar 1.3346   15-Mar 1.3315   16-Mar 1.3423   17-Mar 1.3373   18-Mar 1.331   21-Mar 1.3165   22-Mar 1.321   23-Mar 1.3005   24-Mar 1.2957   25-Mar 1.2954   28-Mar 1.2877   29-Mar 1.2913   30-Mar 1.2944   31-Mar 1.2969