# Question: The file S03 30 xlsx contains monthly data on exchange rates of

The file S03_30.xlsx contains monthly 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 month to month.

a. Create a column of differences for each currency. For example, the difference corresponding to Jan-06 will be blank for each currency because the Dec-05 value isn’t listed, but the difference for Euros in Feb-06 will be 0.8375 - 0.8247.

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 1s on the diagonal are not colored.

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 correlations between two currencies like the Chinese yuan and British pound can be fairly highly negatively correlated, whereas the correlation between their differences is essentially zero? Would you conclude that these two currencies “move together?”

a. Create a column of differences for each currency. For example, the difference corresponding to Jan-06 will be blank for each currency because the Dec-05 value isn’t listed, but the difference for Euros in Feb-06 will be 0.8375 - 0.8247.

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 1s on the diagonal are not colored.

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 correlations between two currencies like the Chinese yuan and British pound can be fairly highly negatively correlated, whereas the correlation between their differences is essentially zero? Would you conclude that these two currencies “move together?”

**View Solution:**## Answer to relevant Questions

The file S02_35.xlsx contains data from a survey of 500 randomly selected (fictional) households. a. Create a table of correlations between the last five variables (First Income to Debt). On the sheet with these ...Solve problem 4 with pivot tables and create corresponding pivot charts. Express the counts as percentage of row. What do these percentages indicate about this particular data set? Then repeat, expressing the counts as ...Building on the previous problem, another pivot table element we didn’t explain is a calculated field. This is usually a new numerical variable built from numerical variables that can be summarized in the Values area. It ...The files S02_29.xlsx contain monthly percentages of on-time arrivals at several of the largest U.S. airports.a. Explain why the current format of either data set limits the kind of information you can obtain with a pivot ...The file S02_12.xlsx includes data on the 50 top graduate programs in the U.S., according to a recent U.S. News & World Report survey.a. Create a table of correlations between all of the numerical variables. Discuss which ...Post your question