Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table reports the percentage of stocks in a portfolio for the nine previous quarter Quarter Stock % 1 st Year 1 2 9

The following table reports the percentage of stocks in a portfolio for the nine previous quarter
Quarter Stock %
1stYear 129.8
2ndYear 131.0
3rdYear 129.9
4thYear 130.1
1stYear 232.2
2ndYear 231.5
3rdYear 232.0
4thYear 231.9
1stYear 330.0
Use trial and error to find a value of the exponential smoothing coefficient alpha that results in a relatively small MSE. Consider smoothing constants of alpha =0.3,0.6, and 0.8.(Round your answers to two decimal places.)
Period Time Series
Value (in %) alpha =0.3
Forecasts (in %) alpha=0.6
Forecasts (in %) alpha=0.8
Forecasts (in %)
129.8
231.0
329.9
430.1
532.2
631.5
732.0
831.9
930.0
What value of the smoothing constant provides the most accurate forecasts?
A smoothing constant of alpha =0.6 provides the best forecast because it has a smaller MSE than alpha=0.3 or 0.8.
A smoothing constant of alpha =0.3 provides the best forecast because its MSE is the median of the three MSE values obtained using smoothing constants of alpha =0.3,0.6, and 0.8.
A smoothing constant of alpha =0.8 provides the best forecast because it has a larger MSE than alpha=0.3 or 0.6.
All three values of the smoothing constant provide the same MSE, so none provide a more accurate forecast than the others.
(c)
Using the exponential smoothing model you developed in part (b), what is the forecast of the percentage of stocks in a typical portfolio for the second quarter of Year 3?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of strategic management

Authors: Charles w. l. hill, Gareth r. Jones

3rd Edition

1111525196, 978-1111525194

More Books

Students also viewed these General Management questions