Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Extra Credit (15 pts): Visualizing Macroeconomic Data and Recognizing Patterns (a) Collect quarterly data on the following economic indicators from 1960Q1 to 202202.3,4 i. Real
Extra Credit (15 pts): Visualizing Macroeconomic Data and Recognizing Patterns (a) Collect quarterly data on the following economic indicators from 1960Q1 to 202202.3,4 i. Real GDP (Percent Change from Year Ago) ii. Core CPI for All Urban Consumers (Percent Change from Year Ago) iii. Unemployment Rate (Percent and Change from Year Ago, Percent) iv. Monetary Base (Billions of Dollars)" v. M2 Money Stock (Billions of Dollars and Percent Change from Year Ago) vi. Effective Fed Funds Rate (Percent) vii. 3-Month U.S. Treasury Bill Rate (Percent) viii. 10-Year U.S. Treasury Bond Yield (Percent) ix. Baa Corporate Bond Yield (Percent) (b) Using Excel, make a line graph for each of the following combinations of time series (observed data). Plot the data on the y-axis and quarters on the x-axis. Be sure to include axis-labels, grids, title and adjust the axes scale accordingly. Move each graph to its own tab in Excel. Graph 1: Real GDP (Percent Change from Year Ago) & Unemployment Rate (Change from Year Ago, Percent) Graph 2: Core CPI for All Urban Consumers (Percent Change from Year Ago) & Unemployment Rate (Percent) Graph 3: Monetary Base & M2 Money Stock (Billions of Dollars) BE CAREFUL: Make sure units are the same! Graph 4: M2 Money Stock (Percentage Change from Year Ago) & Core CPI for All Urban Consumers (Percent Change from Year Ago) Graph 5: All Four Interest Rates (Percent) (c) Document your findings/observations for each graph. For example, you may observe two time series either move in the same or opposite directions or perhaps another interesting observation. Does not need to be a detailed observation. Must complete Questions 1-3 to receive extra credit. "You can obtain quarterly data by using the average aggregation method on the FRED website. FRED reports the Monetary Base in millions, not billions, of dollars, Recall 1 Billion = 1,000 Million
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started