Question
Book Icon
Chapter 21, Problem 2DAP

(a)

To determine

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)

To determine

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)

To determine

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?

Blurred answer
Students have asked these similar questions
Write a summary of the article "Are Emily and Greg more employable than Lakisha and Jamal? A field experiment on labor market discrimination" by Bertrand and Mullainathan (2004). 1200 words aproximately. In the first part of your summary, address the following questions based on the article: 1. What is the research question, and why is it important? 2. What are the main contributions of this study to the literature? 3. What empirical method is used to address the research question? What are the key assumptions for the method? 4. What data are used in the empirical analysis? 5. What are the main findings and conclusions of the paper? In addition to answering these questions, add your own comments, thoughts, or criticisms. For example, you can consider whether you are convinced by the methodology or results and explain why. You can discuss the main advantages of the paper, as well as its main drawbacks or limitations. You may also suggest potential areas for future research that could…
Please don't use Ai solution
O'Reilly's financial analysis trends for 2022, 2023, and 2024
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:9780190931919
Author:NEWNAN
Publisher:Oxford University Press
Text book image
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Text book image
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Text book image
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education