Question

Florida Co x Topic: We X Access to Book 1.xls x Mail Dar x C Sign In orx Microsoft MindTap 6637 Bou x M Your ques X + C https://ng.cengage.com/static/nb/ui/evo/index. html?deploymentid=57360043871 15514484747064 &elSBN=97813371 1 53778&snapshotid=11602478id =476006348&takeId =.. Apps Log In-WordPre. C My Courses - The.. we M GEB3375 MindTap-QMB2 MyUCF CENGAGE MINDTAP Q Search this course Module 9 Homework Consider the following time series date 2 3 Week 4 6 Value 19 13 17 18 15 11 a. Which of the following is e correct time series plot for this date Timeris Vatue 15 LA Wek TaneSwrie Value 5 Week Tineries Value 5 10 A-Z Week Select your answer tern a o data? Horirontal b. Develop three-week moving average faracasts for this time series Compute MSE and a forecast for week 7 (to 2 dacimals if necassary). The forecast for week T e exponential smoathing farecasts for the time series, Compute MSE and a forecast for week 7 (to 2 decimals). c, Use a 2 to computer MSE The forecast for week 7 moving averageaccronch with the exponentisl smonthing acoroachsing a. foreceste herod on MEE3 whirh angenrs to nrovide more accrn Florida Co x Topic: We X Access to Book 1.xls x Mail Dar x C Sign In or x Microsoft MindTap 6637 Bou x M Your ques X + C https://ng.cengage.com/static/nb/ui/evo/index. html?deploymentid=57360043871 15514484747064 &elSBN=97813371 1 53778&snapshotid=11602478id =476006348&takeId =.. Apps Log In-WordPre.. c My Courses The. we MGEB3375 MyUCF MindTap-QMB2 CENGAGE MINDTAP Q Search this course Module 9 Homework 15 Week 4 TaneSwrie Value 0 Week TineSeries Value 10 Week What tyoe of nattern exists in t data? A-Z Horizontal a three-week moving average farecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimas if necessary) b. Develog MSE The forecast for week T e exponential smoathing farecasts for the time series, Compute MSE and a forecast for week 7 to 2 decimals). 2 to campute c. Use a мE The forecast ior wenk T =2. Which appears to provide more accurate forecests based on MSSE? three moving uars ddesa better forecast since it has e smalles u e. Use o smoothing constant of a-.4 to compute MSE (to 2 decimals) Does a smoothing constant of 2 or 4 appeart provide more occurate forecasts based on MSE? The exponential smoothing forecast using a- 4 provides a better forecast than the expanential smoothing forecast using a a 2 since it has a smaller MSE

Answer 1

a) plot 1 is correct

b)

		3 week
Time period	Actual Value(A)	Moving avg. Forecast(F)	Forecast error E=|A-F|	Squared Forecast Error
1	19
2	13
3	17
4	11	16.33	5.33	28.44
5	18	13.67	4.33	18.78
6	15	15.33	0.33	0.11
		Total	10.00	47.33
		Average	3.33	15.78
			MAD	MSE

from above MSE =15.78

and forecast =14.67

c)

MSE =17.26

forecast =16.32

e)

MSE =16.53