The Effective Federal Funds Rate
Remember to properly label and cite your data and graphs. Even more data gathering from FRED… Find monthly, not-seasonally adjusted rates. Find data on the effective Federal Funds Rate. Gather data from July 1954 to the present. What is the current FFR? What year was the highest Federal Funds rate in your data series. Download into Excel and construct a graph of the Effective Federal Funds Rate. Find data for the following: Prime Bank Loan Rate 30 year Conventional Mortgage Rate Automobile Lending Rates. Also find data for: 3 month treasuries constant maturity 3 year tresuries constant maturity 30 year treasuries constant maturity Construct two graphs: Graph One – should include the effective Federal Funds rate, Prime Bank Loan Rate; Mortgage Rate; and Automobile Lending Rates. Graph Two – effective Federal Funds Rate, 3 month treasuries constant maturity; 3 year treasuries constant maturity; and 30 year treasuries constant maturity. These graphs are to be imported into a Word Document. Write a short paragraph discussing some observations you have about the data for each graph. You are expected to present the assignment formally with proper citations. The goals of this assignment are the following: Illustrate your ability to utilize primary sources. Give you experience creating tables using Excel. Give you experience creating graphs using excel. Give you experience presenting the graphs and table in a Word document.