The data shows the average monthly exchange rate between the US dollar and the euro for a certain year. It shows that

$1$

$$euro was equivalent to

$1$

$.$

$2$

$8$

$9$

$$US dollars for January

$2$

$0$

$1$

$6$

$.$

$$

Month Exchange Rate Month Exchange Rate

January

$1$

$.$

$2$

$8$

$9$

$$ July

$1$

$.$

$2$

$3$

$0$

February

$1$

$.$

$3$

$2$

$4$

$$ August

$1$

$.$

$2$

$4$

$0$

March

$1$

$.$

$3$

$2$

$1$

$$ September

$1$

$.$

$2$

$8$

$7$

April

$2$

$.$

$3$

$1$

$7$

$$ October

$1$

$.$

$2$

$9$

$8$

May

$1$

$.$

$2$

$8$

$0$

$$ November

$1$

$.$

$2$

$8$

$3$

June

$1$

$.$

$2$

$5$

$4$

$$ December

$1$

$.$

$3$

$1$

$1$

Answer the following. Present the tables with the corresponding computed values.

$1$

$.$

$$Use the na

$$

ve forecasting technique to obtain the forecasted value for January

$2$

$0$

$1$

$7$

$.$

$2$

$.$

$$Use the

$3$

$-$

month moving average technique to find the forecasted value for January

$2$

$0$

$1$

$7$

$.$

$3$

$.$

$$Forecast the exchange rate for January

$2$

$0$

$1$

$7$

$$using the weighted

$3$

$-$

month moving average, using the weights

$0$

$.$

$5$

$0$

$,$

$0$

$.$

$3$

$0$

$,$

$$and

$0$

$.$

$2$

$0$

$.$

$$

$4$

$.$

$$Using the MSE, determine which of the

$3$

$$methods provided the most accurate forecast.