Module 0B Course Project: Deliverable 1 FRL 3062 Counts as one participation assessment. 10 points. Submit one excel file following the steps below. Due on 9/3 at 11:59pm. This intermediate...

Just need help with parts 3-5. Should only take a few minutes.I already started and sent you what i started, i tried part 3, but im not sure if i did it right.Just need to download the right files and put in the right order on excel thats requested.





Module 0B Course Project: Deliverable 1 FRL 3062 Counts as one participation assessment. 10 points. Submit one excel file following the steps below. Due on 9/3 at 11:59pm. This intermediate deliverable will help you succeed in the final project and keep you on track to have it completely done by its due date (12/3). Detailed discussion of these steps is outlined in videos lectures in folder Module 0B. 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.[footnoteRef:1] [1: For simplicity, use the all-urban, not seasonally-adjusted, all items index.] 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).[footnoteRef:2] [2: SP/Corelogic now requires registration. If you do not want to do this, get the LA (not seasonally adjusted) index from FRED II (google FREDII Case Shiller Los Angeles).] 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.). Submit this file at “BB >> Quizzes & Exams >> Module 0B >> Project Deliverable 1” by 9/3 11:59pm.