CUTTING EDGE CASE

Exponential Smoothing

Template for Exponential Smoothing Forecasting Method
			Exponential
	Time	True	Smoothing	Forecasting					Range Name	Cells
	Period	Value	Forecast	Error		Smoothing Constant			Alpha	H6
	1	6,809	7,500	691		a =	0.5		Forecast	D6:D35
	2	6,465	7,155	690					ForecastingError	E6:E35
	3	6,569	6,810	241		Initial Estimate			InitialEstimate	H9
	4	8,266	6,689	1,577		Average =	7,500		MAD	H12
	5	7,257	7,478	221					MSE	H15
	6	7,064	7,367	303		Mean Absolute Deviation			TrueValue	C6:C35
	7	7,784	7,216	568		MAD =	851
	8	8,724	7,500	1,224
	9	6,992	8,112	1,120		Mean Square Error
	10	6,822	7,552	730		MSE =	1,013,449
	11	7,949	7,187	762
	12	9,650	7,568	2,082
	13		8,609
	14		ERROR:#N/A
	15		ERROR:#N/A
	16		ERROR:#N/A
	17		ERROR:#N/A
	18		ERROR:#N/A
	19		ERROR:#N/A
	20		ERROR:#N/A
	21		ERROR:#N/A
	22		ERROR:#N/A
	23		ERROR:#N/A
	24		ERROR:#N/A
	25		ERROR:#N/A
	26		ERROR:#N/A
	27		ERROR:#N/A
	28		ERROR:#N/A
	29		ERROR:#N/A
	30		ERROR:#N/A

True Value 6809 6465 6569 8266 7257 7064 7784 8724 6992 6822 7949 9650 Forecast 7500 7154.5 6809.75 6689.375 7477.6875 7367.34375 7215.671875 7499.8359375 8111.91796875 7551.958984375 7186.9794921875 7567.98974609375 8608.994873046875 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A

Time Period

Value