ANSWERS TO DATA ANALYSIS PROBLEMS
1. Go to the St. Louis Federal Reserve FRED database, and find data on net worth of
households and non-profits (HNONWRQ027S) and the 10-year U.S. treasury bond (GS10).
For the net worth indicator, adjust the units setting to “Percent Change from Year Ago,” and
for the 10-year bond, adjust the frequency setting to “Quarterly.”
a. What is the percent change in net worth over the most recent year of data available? All
else being equal, what do you expect should happen to the price and yield on the 10-year
treasury bond? Why?
b. What is the change in yield on the 10-year treasury bond over the last year of data
available? Is this result consistent with your answer to part (a)? Briefly explain.
2. Go to the St. Louis Federal Reserve FRED database, and find data on the M1 money supply
the units setting to “Percent Change from Year Ago,” and for the 10-year treasury bond,
adjust the frequency setting to “Quarterly.” Download the data into a spreadsheet.
a. Create a scatter plot, with money growth on the horizontal axis and the 10-year treasury