\begin{tabular}{|c|c|c|c|} \hline 47 & 46 & 9Jan20 & 1.1143 \\ \hline 48 & 47 & 10-Jan-20 & 1.1095 \\ \hline 49 & 48 & 13-Jan-20 & 1.1151 \\ \hline 50 & 49 & 14-Jan-20 & 1.1139 \\ \hline 51 & 50 & 15-Jan-20 & 1.1132 \\ \hline 52 & 51 & 16Jan20 & 1.1113 \\ \hline 53 & 52 & 17Jan20 & 1.1073 \\ \hline 54 & 53 & 21-Jan-20 & 1.1109 \\ \hline 55 & 54 & 22-Jan-20 & 1.1112 \\ \hline 56 & 55 & 23-Jan-20 & 1.1037 \\ \hline 57 & 56 & 24-Jan-20 & 1.1039 \\ \hline 58 & 57 & 27-Jan-20 & 1.1020 \\ \hline 59 & 58 & 28-Jan-20 & 1.1025 \\ \hline 60 & 59 & 29-Jan-20 & 1.1052 \\ \hline 61 & 60 & 30-Jan-20 & 1.1021 \\ \hline 62 & 61 & 31-Jan-20 & 1.1055 \\ \hline \end{tabular} Sheet1 Click here for the Excel Data File (a) Make an Excel line graph of the exchange rate data. Describe the pattern. The pattern observed is (b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing m (e.g., m=2,4,6, etc.). (c) Discuss how this moving average might help a currency speculator. \begin{tabular}{|c|c|c|c|} \hline 47 & 46 & 9Jan20 & 1.1143 \\ \hline 48 & 47 & 10-Jan-20 & 1.1095 \\ \hline 49 & 48 & 13-Jan-20 & 1.1151 \\ \hline 50 & 49 & 14-Jan-20 & 1.1139 \\ \hline 51 & 50 & 15-Jan-20 & 1.1132 \\ \hline 52 & 51 & 16Jan20 & 1.1113 \\ \hline 53 & 52 & 17Jan20 & 1.1073 \\ \hline 54 & 53 & 21-Jan-20 & 1.1109 \\ \hline 55 & 54 & 22-Jan-20 & 1.1112 \\ \hline 56 & 55 & 23-Jan-20 & 1.1037 \\ \hline 57 & 56 & 24-Jan-20 & 1.1039 \\ \hline 58 & 57 & 27-Jan-20 & 1.1020 \\ \hline 59 & 58 & 28-Jan-20 & 1.1025 \\ \hline 60 & 59 & 29-Jan-20 & 1.1052 \\ \hline 61 & 60 & 30-Jan-20 & 1.1021 \\ \hline 62 & 61 & 31-Jan-20 & 1.1055 \\ \hline \end{tabular} Sheet1 Click here for the Excel Data File (a) Make an Excel line graph of the exchange rate data. Describe the pattern. The pattern observed is (b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing m (e.g., m=2,4,6, etc.). (c) Discuss how this moving average might help a currency speculator