[See Steps] Consider the applications for home mortgages data in the file P13_04.xlsx Create a time series chart of the data. Based on what you see, which


Question: Consider the applications for home mortgages data in the file P13_04.xlsx

  1. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think should be used for forecasting? Why?
  2. Use simple exponential smoothing to forecast these data, using no holdout period and requesting 4 quarters of future forecasts. Use the default smoothing constant of 0.1
  3. Repeat part b, optimizing the smoothing constant. Does it make much of an improvement?
  4. Write a short report to summarize your results.

Price: $2.99
Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in