Question: 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)

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
Get step-by-step solutions from verified subject matter experts
