The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.

Closing Prices

Date	A	B	C	D	Stock Exchange
09/03/2010	126.69	18.33	20.87	15.46	10,441.25
09/07/2010	126.39	18.19	20.63	15.29	10,329.98
09/08/2010	125.65	17.81	20.73	15.73	10,426.91
09/09/2010	125.24	18.05	20.52	15.97	10,373.98
09/10/2010	127.21	18.08	20.64	15.95	10,477.25
09/13/2010	128.41	18.68	21.23	16.33	10,511.38
09/14/2010	128.76	18.89	21.32	16.25	10,610.03
09/15/2010	128.51	18.89	21.39	16.39	10,569.69
09/16/2010	128.46	18.84	21.75	16.24	10,510.82
09/17/2010	129.11	18.67	21.88	16.45	10,508.43
09/20/2010	132.39	18.91	21.59	16.57	10,827.93
09/21/2010	132.76	18.96	21.65	16.68	10,806.47

a. Looking at the Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of

0.3.

On the exponential smoothing forecast model for stock A.

(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast A
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 2

Complete the exponential smoothing forecast model for stock B.

(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast B
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 3

Complete the exponential smoothing forecast model for stock C.

(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast C
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 4

Complete the exponential smoothing forecast model for stock D.

(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast D
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 5

Complete the exponential smoothing forecast model for the stock exchange.

(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast Stock Exchange
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 6

b. Compute the MAD, MSE, and MAPE for each of the models.

Compute the MAD (mean absolute deviation) for each of the models.

(Type integers or decimals rounded to two decimal places as needed.)

Stock A		enter your response here
Stock B		enter your response here
Stock C		enter your response here
Stock D		enter your response here
Stock Exchange		enter your response here

Part 7

Compute the MSE (mean square error) for each of the models.

(Type integers or decimals rounded to two decimal places as needed.)

Stock A		enter your response here
Stock B		enter your response here
Stock C		enter your response here
Stock D		enter your response here
Stock Exchange		enter your response here

Part 8

Compute the MAPE (mean square error) for each of the models.

(Type integers or decimals rounded to two decimal places as needed.)

Stock A		enter your response here%
Stock B		enter your response here%
Stock C		enter your response here%
Stock D		enter your response here%
Stock Exchange		enter your response here%

Part 9

c. Does a smoothing constant of

0.1

or

0.5

yield better results?

Select the correct answer below and, if necessary, fill in the answer box to complete the choice.

A.

Neither

0.1

nor

0.5

yield better results because the values of MAD, MSE and MAPE for

=0.3

are all lower.

B.

Neither

0.1

nor

0.5

yield better results because the values of MAD, MSE and MAPE for

=0.3

are all higher.

C.

A smoothing constant of

enter your response here

yields better results because the values of MAD, MSE and MAPE are all lower.

(Type an integer or a decimal.)

D.

A smoothing constant of

enter your response here

yields better results because the values of MAD, MSE and MAPE are all higher.

(Type an integer or a decimal.)

a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of

0.3.

Complete the exponential smoothing forecast model for stock A.(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast A
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 2Complete the exponential smoothing forecast model for stock B.(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast B
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 3Complete the exponential smoothing forecast model for stock C.(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast C
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 4Complete the exponential smoothing forecast model for stock D.(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast D
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 5Complete the exponential smoothing forecast model for the stock exchange.(Type integers or decimals rounded to two decimal places as needed.)

Date	Forecast Stock Exchange
09/03/2010
09/07/2010	enter your response here
09/08/2010	enter your response here
09/09/2010	enter your response here
09/10/2010	enter your response here
09/13/2010	enter your response here
09/14/2010	enter your response here
09/15/2010	enter your response here
09/16/2010	enter your response here
09/17/2010	enter your response here
09/20/2010	enter your response here
09/21/2010	enter your response here

Part 6b. Compute the MAD, MSE, and MAPE for each of the models.Compute the MAD (mean absolute deviation) for each of the models.(Type integers or decimals rounded to two decimal places as needed.)

Stock A		enter your response here
Stock B		enter your response here
Stock C		enter your response here
Stock D		enter your response here
Stock Exchange		enter your response here

Part 7Compute the MSE (mean square error) for each of the models.(Type integers or decimals rounded to two decimal places as needed.)

Stock A		enter your response here
Stock B		enter your response here
Stock C		enter your response here
Stock D		enter your response here
Stock Exchange		enter your response here

Part 8Compute the MAPE (mean square error) for each of the models.(Type integers or decimals rounded to two decimal places as needed.)

Stock A		enter your response here%
Stock B		enter your response here%
Stock C		enter your response here%
Stock D		enter your response here%
Stock Exchange		enter your response here%

Part 9c. Does a smoothing constant of

0.1

or

0.5

yield better results?Select the correct answer below and, if necessary, fill in the answer box to complete the choice.

A.

Neither

0.1

nor

0.5

yield better results because the values of MAD, MSE and MAPE for

=0.3

are all lower.

B.

Neither

0.1

nor

0.5

yield better results because the values of MAD, MSE and MAPE for

=0.3

are all higher.

C.

A smoothing constant of

enter your response here

yields better results because the values of MAD, MSE and MAPE are all lower.

(Type an integer or a decimal.)

D.

A smoothing constant of

enter your response here

yields better results because the values of MAD, MSE and MAPE are all higher.

(Type an integer or a decimal.)