Question

1. [1pt] Google the St Louis Economics Database (“Fred II”) and download the excel monthly constant maturity 1-year (GS1) and
2. [1pt] monthly 10-year series (GS10).
3. [1pt] Similarly, google the Bureau of Labor Statistics (“BLS”) and create a spreadsheet of the monthly all-urban CPI (“inflation”) index.[1]
4. [1pt] Download the nominal Case-Shiller index for the Los Angeles by similarly obtaining the necessary data from a web-search (Standard and Poor’s or FRED II).[2]
5. [1pt] Download the (not seasonally adjusted) monthly shelter component of CPI for LA/Orange/Riverside (or LA-Long Beach Anaheim).
6. [5pts] Place all 5 data sets in 5 separate Sheets within one Excel file. Rename the sheets to match the content (e.g., GS1, GS10, etc.).

Answer 1

We are unable to upload excell.So, here are the screeshots of the question.

Los Angeles-Long Beach-Anaheim, CA, CPI-U 1-month and 12-month percent changes, all items index, not seasonally adjusted
Month	2016	2017	2018	2019	2020
1-month	12-month	1-month	12-month	1-month	12-month	1-month	12-month	1-month	12-month
January	0.7	3.1	0.9	2.1	0.8	3.5	0.7	3.2	0.8	3.1
February	0	2.4	0.6	2.7	0.7	3.6	0.1	2.5	0.3	3.4
March	0.3	1.7	0.3	2.7	0.4	3.8	0.6	2.7	-0.7	1.9
April	0.2	2	0.2	2.7	0.4	4	1	3.3	-0.3	0.7
May	0.5	1.4	0.3	2.5	0.4	4.1	0.2	3.1	0.4	0.9
June	0.1	1.8	-0.2	2.2	-0.2	4	0	3.3	0.5	1.4
July	0	1.1	0.3	2.5	0.2	3.9	0.1	3.3	0.6	1.9
August	0	1.4	0.3	2.8	0.2	3.9	0	3
September	0.2	1.9	0.4	3.1	0.5	3.9	0.5	3
October	0.4	2.2	0.4	3.1	0.5	4.1	0.7	3.2
November	-0.4	1.8	0.1	3.6	-0.3	3.6	-0.3	3.2
December	0	2	0	3.6	-0.3	3.2	-0.6	3