The below table shows the dataset of 15 observations on the spot and three months forward rates between the A$ and the C$, as well as the C$ 3-month interest rates. On the basis of this dataset, you are required to do the following (Home Country: Australia):

Calculate the interest rate parity-forward rate and plot it against the actual forward rate

Calculate the percentage deviation of the actual forward rate from the interest parity

forward rate and plot it.

Calculate the covered margin and plot it

Also, the fit the interest rate parity in 1 observation

Observation SPOT AUD/CAD 1.0643 1.1000 11.1003 1.0672 11.0449 1.0170 1.0447 1.0555 1.01365 1.1325 1.2259 1.1942 1.3066 1.2918 1.2890 FORWARD AUD/CAD 1.0692 1.1037 1.0904 1.0520 1.0440 1.0188 1.0398 1.0538 1.1339 1.1295 1.2163 1.1969 1.3165 1.2941 1.2838 AUSTRAILIAN CANADIAN INTEREST INTEREST 4.84 4.59 4.93 4.87 4.85 4.91 4.62 4.66 4.66 4.63 4.70 4.56 4.78 4.66 5.08 4.85 5.78 5.27 5.53 6.41 5.56 6.03 5.49 4.98 4.58 4.88 4.30 4.30 3.05 5.87 Observation SPOT AUD/CAD 1.0643 1.1000 11.1003 1.0672 11.0449 1.0170 1.0447 1.0555 1.01365 1.1325 1.2259 1.1942 1.3066 1.2918 1.2890 FORWARD AUD/CAD 1.0692 1.1037 1.0904 1.0520 1.0440 1.0188 1.0398 1.0538 1.1339 1.1295 1.2163 1.1969 1.3165 1.2941 1.2838 AUSTRAILIAN CANADIAN INTEREST INTEREST 4.84 4.59 4.93 4.87 4.85 4.91 4.62 4.66 4.66 4.63 4.70 4.56 4.78 4.66 5.08 4.85 5.78 5.27 5.53 6.41 5.56 6.03 5.49 4.98 4.58 4.88 4.30 4.30 3.05 5.87