Section II (30 points):
Using the Fed website - (https:
www.federalreserve.gov
eleases/h10/hist) as your source,
collect daily exchange rates for the period from January 1, XXXXXXXXXXSeptember 30, 2020 for the
cu
ency chosen. Compute the mean (5), standard deviation/volatility (5) and percent
appreciation/depreciation (5) for the cu
ency for the following periods:
January 1, 2018 – September 30, 2020 (entire period)
January 1, 2018 – March 31, 2018
April 1, 2018 – June 30, 2018
July 1, 2018 – September 30, 2018
October 1, 2018 – December 31, 2018
January 1, 2019 – March 31, 2019
April 1, 2019 – June 30, 2019
July 1, 2019 – September 30, 2019
October 1, 2019 – December 31, 2019
January 1, 2020 – March 31, 2020
April 1, 2020 – June 30, 2020
July 1, 2020 – September 30, 2020
- Create a line graph plotting the daily exchange rates for the entire period (the dates on the
horizontal axis). (5)
- Write a description based on the statistics calculated and the graph (both statistics and
graphs are part of the report XXXXXXXXXX)
- Include your data source in the bibliography.
Notes:
1. Use direct quotes
2. If the quote for any date is missing, please assume the exchange rate of the previous date for that
date.
3. The excel file (containing the data and computations) as well as the word document (containing the
table of statistics, the graph and the description) need to be uploaded to the D2L folder.
(https:/www.federalreserve.gov
eleases/h10/hist