Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1. (32 pts) To answer this question, see the instructions on the course website for how to download data from FRED: (1) (16 pts)

image text in transcribed
Question 1. (32 pts) To answer this question, see the instructions on the course website for how to download data from FRED: (1) (16 pts) Download seasonally adjusted real GDP (in billions of chained 2012 dol lars), the real residential property price, and the effective FED funds rate. All three variables should be quarterly and cover only the period 1978-01-01 to 2019-0101 for the U.S.. Put these data sets together in a new Excel sheet, where the rst column (A) should be the quarterly dates. Transform each of the variables by dividing the variable by its average. Put the transformed variable in a new column. Submit the printed form of the Excel sheet that contains the original data and the transformed data. Clearly label each column. (2) (8 pts) Plot the transformed GDP and the transformed housing price in one graph where the horizontal axis is time. Clearly label the plotted data. Use this graph to discuss the relationship and the contrast between the behavior of real GDP and the housing price. (3) (8 pts) Plot the transformed housing price and the transformed effective federal funds rate in one graph where the horizontal axis is time. Clearly label the plotted data. Use this graph to discuss the relationship and the contrast between the housing price and the effective federal funds rate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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 And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

Students also viewed these Economics questions