Skodel Ltd is considering investing into technology stocks. As a test case, it looked at Microsoft-adjusted monthly

Question:

Skodel Ltd is considering investing into technology stocks. As a test case, it looked at Microsoft-adjusted monthly closing values of stocks between 1 March 2001 and 1 August 2008. The time series is given in Table 9.15

26.21 25.72 27.51 28.32 28.42 28.28 27.1 32.35 35.33 33.35 36.41 29.14 28.42 28.58 29.05 Table 9.15 30.25

Use the exponential smoothing method and experiment with various levels of the smoothing constant. See what impact it has on your forecasts and how it changes the forecasting errors. Make a recommendation as to what approach to forecasting you would use and why.

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

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: