(a)
Go to the St. Louis Federal Reserve databased, and find data on the monthly U.S dollar exchange rate to the Chinese yuan (EXCHUS), the Canadian dollar (EXCAUS) and the South Korean won (EXKOUS).
For the most recent 5-year period of data available, use the average, max, min, and standard deviation functions in Excel to calculate the average, highest, and lowest exchange rate values, as well as the standard deviation of the exchange rate to the dollar (this is an absolute measure of the volatility of the exchange rate)
(b)
Using the maximum and minimum values of each exchange rate over the last five years, calculate the ratio of the difference between the maximum and minimum values to the average level of the exchange rate (expressed as a percentage by multiplying by 100). Based on the results, which of the three countries is most likely to peg its currency to the US dollar? How does this country’s currency compare with the other two?
(c)
Calculate the ratio of the standard deviation to the average exchange rate over the last five years (expressed as a percentage by multiplying by 100). Based on your results, which of the three currencies is most likely to be pegged to the US dollar? How does this currency compare with the other two?
Want to see the full answer?
Check out a sample textbook solutionChapter 21 Solutions
EBK THE ECONOMICS OF MONEY, BANKING AND
- Principles of Economics (12th Edition)EconomicsISBN:9780134078779Author:Karl E. Case, Ray C. Fair, Sharon E. OsterPublisher:PEARSONEngineering Economy (17th Edition)EconomicsISBN:9780134870069Author:William G. Sullivan, Elin M. Wicks, C. Patrick KoellingPublisher:PEARSON
- Principles of Economics (MindTap Course List)EconomicsISBN:9781305585126Author:N. Gregory MankiwPublisher:Cengage LearningManagerial Economics: A Problem Solving ApproachEconomicsISBN:9781337106665Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike ShorPublisher:Cengage LearningManagerial Economics & Business Strategy (Mcgraw-...EconomicsISBN:9781259290619Author:Michael Baye, Jeff PrincePublisher:McGraw-Hill Education