Question: Refer to the DJIA data in Problem 5-37. (a) Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA

Refer to the DJIA data in Problem 5-37.
(a) Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA index value for 2011. Find the MSE for this.
(b) Use QM for Windows or Excel and find the smoothing constant that would provide the lowest MSE.

Step by Step Solution

★★★★★

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a With a smoothing constant of 04 the fo... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

162-M-S-F (71).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Refer to the DJIA data in Problem 5- 39. In Problem 5-39, The following table provides the Dow Jones Industrial Average (DJIA) opening index value on the first working day of 19942013: Develop a...

Refer to the DJIA data in Problem 5-41. (a) Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA index value for 2014. Find the MSE for this. (b) Use QM for...

In what way is an exponential smoothing model really a moving average model?

5-41 data 5-43 Refer to the DJIA data in Problem 5-41. a. Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA index value for 2014. Find the MSE for this....

5-41 Refer to the DJIA data in Problem 5-39. (a) Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA index value for 2014. Find the MSE for this. (b) Use...

day of the week Daily Dem Average Daily price per pack Monday 297 11.1 Tuesday 293 10.055 Wednesday 327 9.77 Thursday 315 10.6 Friday 348 9.59 Saturday 447 8.965 Sunday 431 10 Monday 283 10.16...

1 (2 points) Which of the following statements are true? Question 1 options: Probabilities must be negative. Probabilities can either be positive or negative. Probabilities must be nonnegative....

Problem The Excel file Closing Stock Prices provides data for four stocks and the Down Jones Industrial Average (DJIA) over one month. a. Develop a spreadsheet model for forecasting each of the stock...

Market Demand Forecast Method Selection and Application: A Case Study in Hero MotoCorp Ltd. D K Choudhury Abstract: In this dynamic era, the market is very competitive and the demand for a product...

How should contingent liabilities that are reasonably possible of becoming liabilities be reported in the financial statements?

a. During February, $186,500 was paid to creditors on account, and purchases on account were $201,400. Assuming the February 28 balance of Accounts Payable was $59,900 determine the account balance...

You have been hired as a consultant for Pristine Urban - Tech Zithec, Incorporated ( PUTZ ) , manufacturers of fine zithers. The market for zithers is growing quickly. The company bought some land...

19. How old is that tree? One can determine how old a tree is by counting its rings, but that requires either cutting the tree down or extracting a sample from the trees core. Can we estimate the...

=12. In the standard queuing model, we assume that the queue discipline is .

=3. In a multichannel, single-phase queuing system, the arrival will pass through at least two different service facilities. a. True b. False

=2. Before using exponential distributions to build queuing models, the quantitative analyst should determine if the service time data fit the distribution. a. True b. False

Topic: Bond Returns 11) For each of the below, indicate True or False. No explanation is required. a) Given: At t = 0 you bought a 3-year, 9% coupon bond with a 7% YTM. You held the position until t...

TwitterMe, Inc., is a new company and currently has negative earnings. The companys sales are $2,100,000 and there are 150,000 shares outstanding. 1. If the benchmark price-sales ratio for the...

Lea los siguientes dos ejercicios con calma, usando los conceptos aprendidos en la clasecontestelos dos problemas que se presentan a continuacin: Problema1: Una empresa de publicidad localizada enSan...