Question: F I L E Consider the following table, which shows a portion of the closing prices of the S&P 500 Index for 21 trading days

F I L E Consider the following table, which shows a portion of the closing prices of the S&P 500 Index for 21 trading days in November 2010. The complete data set can be found on the text website, labeled S&P Price.

Date S&P Price 1-Nov 1184.38 2-Nov 1193.57

⋮ ⋮

30-Nov 1180.55 Source: finance.yahoo.com .

a. Use a 3-period moving average to make a price forecast for December 1,2010.

b. Use the exponential smoothing method to make a price forecast for December 1,2010. Use α = 0.4.

c. Which of the above smoothing methods results in a lower MSE?

d. You find out that the actual S&P 500 closing price on December 1,2010 was 1,206.07. Was the forecast performance of the two methods consistent with their in-sample performance in part c?

Step by Step Solution

3.34 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Communicating Questions!