The data in CPI-U reflect the annual values of the consumer price index (CPI) in the United

Question:

The data in CPI-U reflect the annual values of the consumer price index (CPI) in the United States over the 50-year period 1965 through 2014, using 1982 through 1984 as the base period. This index measures the average change in prices over time in a fixed "market basket" of goods and services purchased by all urban consumers, including urban wage earners (i.e., clerical, professional, managerial, and technical workers; self-employed individuals; and short-term workers), unemployed individuals, and retirees. (Data extracted from Bureau of Labor Statistics, U.S. Department of Labor, www.bls.gov.)

a. Plot the data.

b. Describe the movement in this time series over the 48-year period.

c. Compute a linear trend forecasting equation and plot the trend line.

d. Compute a quadratic trend forecasting equation and plot the results.

e. Compute an exponential trend forecasting equation and plot the results.

f. Which model is the most appropriate?

g. Using the most appropriate model, forecast the CPI for 2015 and 2016.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 9780134173054

8th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: