What cpi value would you predict for july 2022

Assignment Help Managerial Accounting

Reference no: EM133247760

Problem

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 2012? Why is this answer different from the one in part b)?

Make 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: EM133247760

Questions Cloud

Cultural variations within nations : Cultural differences between nations are more or less important than cultural variations within nations.

Similarities and differences between your viewpoints : MGT 221 Post University discuss the similarities and differences between your viewpoints. Refer to the video in the Readings and Resources section

Marketing and communicating about property : Explain at least two ethical considerations required when marketing and communicating about property?

Discuss the expandgrid function : Using the "expandgrid" function, how many possible combinations of rolls are there?

What cpi value would you predict for july 2022 : MGMT 101 University of California, Using an exponential smoothing model with a smoothing constant of 0.2, what CPI value would you predict for July 2022?

Future strategic marketing initiative : Identify potential barriers that might prevent you from reaching your stated career goals and objectives.

Merrill-reid social style model : How Financial Advisors can use a strong understanding of Merrill-Reid Social Style Model to enhance relationships with customers?

Describe the extent of income and wealth inequality : Describe the extent of income and wealth inequality in the USA today. Why has wealth inequality increased in the USA in the last 40 years

Whats the core priority of corporate managers : FINANCE 500 North Carolina State University Whats the Core Priority of Corporate Managers article post by Irving Wladawsky-Berger Guest Contributor

User Account

All Pages