Answer & Explanation:CPU VALUES
qrb501_week_6.xlsx
qrb501_r10_signature_assignment_formulas.doc
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
