The S&P 500 reached an all-time high September 27th, 2018, at 2,914. The data in excel file

Question:

The S&P 500 reached an all-time high September 27th, 2018, at 2,914. The data in excel file S&P 500 show the end-of-the-month value for the S&P 500 for the last two years.

a. Construct a graph showing the S&P Index over time.

b. Forecast the S&P Index for the end of October 2018 using exponential smoothing with α = 0.2.

c. Calculate the MAD for the forecast in part b.

d. Forecast the S&P Index for the end of October 2018 using exponential smoothing with trend adjustment and setting α = 0.2 and β = 0.5.

e. Calculate the MAD for the forecast in part d.

f. In which forecast do you have the most confidence?

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

Step by Step Answer:

Related Book For  answer-question

Business Statistics

ISBN: 9780134685267

3rd Edition

Authors: Robert A. Donnelly

Question Posted: