CPU Values, economics homework help

User Generated

ZON33615

Economics

Description

CPU VALUES

Unformatted Attachment Preview

INTRUCTIONS 1. Search for the Federal Reserve Bank of St. Louis (FRED). 2. On the home page of the website, you will see a search box. 3. Type in CPI- AUCSL in the search box and press the return key. 4. The first result of the search will be "Consumer Price Index for All Urban Consumers: All Items." Click on this result link. 5. Click on the Download link and download the data in Excel®. ® 6. On the Excel file, the second column gives you the CPI values for each period starting from 1947. 7. Go to the last row and notice the last date and the CPI value. Go back 6 years from this last date. For example, if the last da ® 8. Copy and paste this six years data into a separate Excel tab. 9. Using Excel®, calculate the percentage change in CPI from a year earlier for each observation, beginning with the observatio 10. This new column contains the national inflation rate. 11. Create a line graph of the percentage changes (inflation rates) from a year earlier. 12. Which period experienced the highest inflation rate? What was the inflation rate during that period ion, beginning with the observation one year later than the first observation. To make this calculation, click on the blank cell next to the o lick on the blank cell next to the observation corresponding to that date and then use Formula 1, located in the Signature Assignment Exc d in the Signature Assignment Excel ® Formulas document (note that in Excel®, the symbol for multiplication is *), where t-1 is the first obs ion is *), where t-1 is the first observation and t is the observation one year later. For example, to find the percentage change in CPI from the percentage change in CPI from 2010-11-01 to 2010-10-01, refer to Formula 2 located in the Signature Assignment Excel ® Formulas do re Assignment Excel ® Formulas document. Convert this value to a percentage in Excel®. Repeat this process for the remaining observation ess for the remaining observations (you can use the copy and paste functions to avoid having to retype the formula). he formula). Signature Assignment Formulas QRB/501 Version 10 University of Phoenix Material Signature Assignment Formulas Formula One Formula Two Copyright © 2017 by University of Phoenix. All rights reserved. 1
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, Please check the attached excel file for details, let me know if you haveany questions, thank you. James,

2011-03-01
2011-04-01
2011-05-01
2011-06-01
2011-07-01
2011-08-01
2011-09-01
2011-10-01
2011-11-01
2011-12-01
2012-01-01
2012-02-01
2012-03-01
2012-04-01
2012-05-01
2012-06-01
2012-07-01
2012-08-01
2012-09-01
2012-10-01
2012-11-01
2012-12-01
2013-01-01
2013-02-01
2013-03-01
2013-04-01
2013-05-01
2013-06-01
...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags