table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl17 {color:windowtext; vertical-align:middle; background:#9BC2E6; mso-pattern:black none;} .xl18 {color:windowtext; vertical-align:middle; background:#A9D08E; mso-pattern:black none;} .xl19 {color:windowtext; font-weight:700; vertical-align:middle;} .xl20 {color:windowtext; vertical-align:middle;} .xl21 {color:windowtext; vertical-align:middle;} .xl22 {color:windowtext; font-weight:700; text-align:center; vertical-align:middle;} .xl23 {color:windowtext; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; vertical-align:middle;} .xl24 {color:windowtext; text-align:center; vertical-align:middle;} .xl26 {color:windowtext; font-weight:700; text-align:center; vertical-align:middle; white-space:normal;} .xl27 {color:windowtext;} .xl32 {color:windowtext; text-align:right; vertical-align:middle;} .xl38 {color:windowtext; text-align:left; vertical-align:middle; background:#A9D08E; mso-pattern:black none;}

Moving Average Forecasting
Periods in moving average	3
	Time Period	Demand	Forecast	Error	Error^2
	1	83
	2	87
	3	82
	4	83
	5	86
	6	90
	7	86
	8	92
	9	95
	10	97
	11	93
	12	94
Next period forecast:	13
		MSE
Periods in moving average	4
	Time Period	Demand	Forecast	Error	Error^2
	1	83
	2	87
	3	82
	4	83
	5	86
	6	90
	7	86
	8	92
	9	95
	10	97
	11	93
	12	94
Next period forecast:	13
		MSE
Which moving average is best?

A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three-period and four-period moving average forecasts and answer the following questions. Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal places. 5