See attached.
Section II (30 points): Using the Fed website - (https://www.federalreserve.gov/releases/h10/hist) as your source, collect daily exchange rates for the period from January 1, 2018 - September 30, 2020 for the currency chosen. Compute the mean (5), standard deviation/volatility (5) and percent appreciation/depreciation (5) for the currency 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). (5 + 5) - 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/releases/h10/hist