https://www.bankofcanada.ca/rates/banking-and-financial-statistics/selected-monetary-aggregates-and-their-components-formerly-e1/

https://www.bankofcanada.ca/rates/price-indexes/cpi/

I NEED HELP WITH THIS

There are two parts in this problem: a) (9 points) Go to the website https://www.bankofcanada.ca/rates/banking-and-financial-statistics/selected-monetary-aggregates-and- their-components-formerly-e1/ and obtain MONTHLY data for the period January 1990 to December 2020 for: Currency outside banks (Seasonally adjusted): variable id=V37148 . Mi+, (gross) (Seasonally adjusted): variable id=V37151 . M2 (gross) (Seasonally adjusted): variable id=V41552796_E1 Scroll down and click "CSV" to download the data to an Excel file. Use Excel or any other software to plot the three variables over time and indicate which of the three is the narrowest monetary aggregate and which one is the broadest monetary aggregates. Explain why the three aggregates are different. b) (16 points) Go to the website https://www.bankofcanada.ca/rates/price-indexes/cpi/ and obtain MONTHLY data for the period January 1995 to December 2020 for the Total CPI, (seasonally adjusted): variable id=V41690914. Now use these CPI data and the M, + data from part (a) to calculate the annual growth rate of both Mi + and the consumer price index (CPI) for the period January 1996 to November 2020 using the following formula: X year Growth X Year month - X Year-1 month month = 100 Yyear-1 month For example, the variable X in April of 2007 would be X 2007, April and for that reason, its growth rate in that month is equal to 2007 _ X 2006 Growth X 2007 = 100- April April April X 2006 April What is the relationship (correlation) between Mi + and consumer price index (CPI) in levels (the values of Mi + and the CPI index)? What is the relationship (correlation) between them when we use annual growth rates rather than levels? Do not forget to