90.2K

Verified Solution

Link Copied!

The following time series shows the sales of aparticular product over the past 12 months. can be found in thebelow excel file.

https://drive.google.com/file/d/1gIpr0IBYUGgCIRSO7g3mqZ84F89vJU_P/view?usp=sharing

1. Using the three-month moving average, what is the MeanSquared Error (MSE)?

(Round your answer to 2 decimal places. Negative valuesshould be indicated by a minus sign.)

2.  Using the three-month moving average, what is theforecast for month 13 ?

(Round your answer to 2 decimal places. Negative valuesshould be indicated by a minus sign.)

3. Using the exponential smoothing approach for ? .3 or .7, whatis the Mean Squared Error (MSE)?  

(Round your answer to 2 decimal places. Negative valuesshould be indicated by a minus sign.)

4. Using the exponential smoothing approach for , .3 or .7, whatis the forecast for month 13?

(Round your answer to 2 decimal places. Negative valuesshould be indicated by a minus sign.)

5. Using the exponential smoothing approach for , .5 or .5, whatis the Mean Squared Error (MSE)?

(Round your answer to 2 decimal places. Negative valuesshould be indicated by a minus sign.)

6. Using the exponential smoothing approach for , .5 or .5, whatis the forecast for month 13?

(Round your answer to 2 decimal places. Negative valuesshould be indicated by a minus sign.)

7. Does a smoother constant of .3 or .5 provide more accurateforecasts based on MSE ?

	.3
	.5