Categories

# 1. Determine the actual numerical change in the CPI from January to December of each year from 2000 to 2019.

You are provided with 3 spreadsheets.

a)       ECO 105 CPI for All Urban Consumers (CPI-U) SeriesReport-20201029022657_f63149

b)       ECO 105 Labor Force Statistics from the Current Population Survey SeriesReport-20200429151252_417a96

d)      GDP

1.       Determine the actual numerical change in the CPI from January to December of each year from 2000 to 2019.

2.      Which year shows the greatest increase?

3.       Find the percentage change in the CPI from January to December of each year from 2000 to 2019.

4.      Which year shows the greatest decrease?

5.       Use the Consumer Price Index (CPI) spreadsheet to compute the average CPI for the years 2000 through 2019.

6.       Use the Labor Force Statistics spreadsheet to find the December unemployment rates for 2010 through 2019.

7.       Create a graph/chart including the year, the average CPI and the December unemployment rates for 2010 through 2019.  You may use separate graphs if needed.

8.       Copy the GDP information for 2000 to 2020 from the GDP spreadsheet into the CPI spreadsheet.

9.       Find the GDP percent change (increase/decrease) for each year from 2000 to 2020.

10.     Create a graph/chart including the year, the December CPI, the Average CPI, and the percent change (increase/decrease) GDP from 2010 to 2019.  You may use separate graphs if needed.

11.    What relationship do you see with the CPI and the GDP during the period 2010 to 2019.

12.     Create a graph/chart including the year, the December CPI, the Average CPI, the December unemployment rate, and the percent change (increase/decrease) GDP from 2010 to 2019.  You may use separate graphs if needed.

13.    Is there any apparent interaction with the unemployment rate and the CPI or the GDP?