6

Problem 3 (6.5 pts) This problem is to be solved and presented on Excel. From the Bank of Canada website obtain the following data (on excel): A. 1-Month Treasury Bills Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) B. 10-Year Bonds Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) C. Draw on the same graph the 1-Month Treasury Bills Yields and the 10-Year Bonds Yields that you have obtained from steps A and B above. (3 pts) D. What do you observe? Can you link the trends that you observe to some events happening around you? (1.5 pts)Problem 3 (6.5 pts) This problem is to be solved and presented on Excel. From the Bank of Canada website obtain the following data (on excel): A. 1-Month Treasury Bills Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) B. 10-Year Bonds Yields at daily frequency from Jan 1, 2019 till Sep 30, 2022. (1 pt) C. Draw on the same graph the 1-Month Treasury Bills Yields and the 10-Year Bonds Yields that you have obtained from steps A and B above. (3 pts) D. What do you observe? Can you link the trends that you observe to some events happening around you? (1.5 pts)