Question
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.
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advanced Management Accounting
Authors: Maurice L. Hirsch Jnr.
2nd Edition
1861526768, 978-1861526762
