Mastering M2 Money Supply Analysis: A Step-by-Step Guide

Assignment #00 Completion is required. While I expect each of you to be able to do each of these questions you are permitted to work in groups of between 1 and 5 students. Each student group is required to put their names in the single submitted Word file in the Sakai assignments page. If you do not complete Assignment #00 you will not be eligible to submit either of the other written assignments for the semester. Grades on Assignment 00 will reflect a level of effort rather than specific performance on any question. In other words its purpose is to force you to refresh yourself with EXCEL and begin thinking more analytically about things. The expectation is that you will have access to this assignment sheet as well as the data file ASSGN00.xlsx. The tabs (or worksheets) in ASSGN00.xlsx are labelled per the questions below. Use the data in the tab “M2BasicData.” You are asked to do some manipulations and calculations with the data on the M2 money supply. Specifically the result we are looking for is the Year over Year % change by month in M2 from January 2020 to April 2022. There are some instructions in the tab “M2BasicData” that are intended really to allow you to follow along. Either way, you can do the problem any way you want. The result is that you have the numbers to fill in the table below “Yearly % Change in M2 – by Month January 2020 – April 2022.” Yearly % Change in M2 - by Month January 2020 - April 2022                     Year.Month Yearly % Change in M2   Year.Month Yearly % Change in M2 2