Create a scatterplot of the monthly cpi between january 2019

Reference no: EM133557791

Everybody is talking about inflation right now. The most popular indicator for inflation is the CPI and reported by the U.S. Bureau of Labor Statistics. Worksheet "CPI" in "Assignment 5.xlsx" contains monthly values of the Consumer Price Index between January 2019 and June 2022 (in column D).

Using moving averages over 5 months, what CPI value would you predict for July 2022?
Using an exponential smoothing model with a smoothing constant of 0.2, what CPI value would you predict for July 2022? Why is this answer different from the one in part a)?
Using an exponential smoothing model with a smoothing constant of 0.8, what CPI value would you predict for July 2022? Why is this answer different from the one in part b)?
Create a scatterplot of the monthly CPI between January 2019 and June 2022. What does this scatterplot tell you? Should you have used the forecasting techniques in parts a) - c) in this case? Why? Why not?
Develop a simple linear regression model with the 42 months ("Period") as the independent and the corresponding CPI values as the dependent variable. How well does your model fit the data? Do you think this is a better model than the ones used in parts a) - c)? Why? Why not?
Using your regression model from part e), predict the CPI value in December 2022. Could you have made such a prediction based on the models from parts a) - c)? Why? Why not?

Reference no: EM133557791

Questions Cloud

Explain how each poem works, what each poem message is : explain how each poem works, what each poem's message is, and how the form and/or language help along this message. In other words, how does one poem present

What type of order would you place for this particular : What price would you face a 30% maintenance margin call? Explain based on your rationale, why would you consider shorting Qantas stocks

Compare the income statements of two different companies : Compare the Income Statements of two different companies in the same industry Target and Walmart 2. Identify any significant differences

What would constitute suspicious activity when it comes : what would constitute suspicious activity when it comes to financial transactions? Use the link below to help you with this assignment.

Create a scatterplot of the monthly cpi between january 2019 : Create a scatterplot of the monthly CPI between January 2019 and June 2022. What does this scatterplot tell you? Should you have used the forecasting techniques

What are the effects on college students of working : What are the causes of cyber-bullying? Why do some people become cyber-bullies? What are the effects on college students of working while taking classes?

Estimate the insurance premium for abacus parcel delivery : Estimate the Insurance premium for Abacus Parcel Delivery Service - Show your calculations.

What has been your experience learning grammar : What has been your experience learning grammar? Has your education been more in the camp of Grammar 1 or Grammar 2? (Think back to your time before college

Do consumers participate in making organisational decision : Do consumers participate in making key organisational decisions? Do you have systems in place to seek and act on consumer feedback?

User Account

All Pages