Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Marketing

Authors: Philip Cateora

16th Edition

0073529974, 9780073529974

More Books

Students also viewed these Economics questions

Question

1. What will happen in the future

Answered: 1 week ago

Question

3. Avoid making mistakes when reaching our goals

Answered: 1 week ago