Using excel create a graph that includes both the mortgage


Figure 14-7 illustrates the relationship between mortgage interest rates and the share of residential investment in GDP. Another way of looking at the same relationship is to take housing starts instead of the share of residential investment.

a. Go to https://research.stlouisfed.org/fred2 . Click on "Interest Rates," "30yr Mortgage," and download the series "MORTG" for 30-year conventional mortgage rates. Go to www.census.gov . Click on "Housing," then on "Construction" under "Related Sites for Housing Data." Next to "Housing Starts," choose the seasonally adjusted annual rate and download the data.

b. Using EXCEL, create a graph that includes both the mortgage interest rates and the housing starts. Visually, what is the relationship between these two variables?

Request for Solution File

Ask an Expert for Answer!!
Econometrics: Using excel create a graph that includes both the mortgage
Reference No:- TGS01520734

Expected delivery within 24 Hours