The file P03_30.xlsx contains daily data on exchange rates of various currencies versus the U.S. dollar. It is of interest to financial analysts and economists to see whether exchange rates move together through time. You could find the correlations between the exchange rates themselves, but it is often more useful with time series data to check for correlations between differences from day to day.
a. Create a column of differences for each currency.
b. Create a table of correlations between all of the original variables. Then on the same sheet, create a second table of correlations between the difference variables. On this same sheet, enter two cutoff values, one positive such as 0.6 and one negative such as Ă˘Ë†â€™0.5, and use conditional formatting to color all correlations (in both tables) above the positive cutoff green and all correlations below the negative cutoff red. Do it so that the 1Ă˘â‚¬â„˘s on the diagonal are not colored.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You wonâ€™t have to worry about the quality and deadlinesOrder Paper Now
c. Based on the second table and your coloring, can you conclude that these currencies tend to move together in the same direction? If not, what can you conclude?
d. Can you explain how the correlation between two currencies can be fairly highly negatively correlated, whereas the correlation between their differences is essentially zero? Would you conclude that these two currencies Ă˘â‚¬Ĺ“move together?Ă˘â‚¬Âť (Hint: There is no easy answer, but scatterplots and time series graphs for these two currencies and their differences are revealing.)