Architecture and Design Assignment For

KnowKneadStudentFileNo.1Solution1.xlsx

Home >Architecture and Design homework help >Architecture and Design Assignment For

DailyData

Individual Forecasting Interpretation Assignment, QNT 5160
File No. 1 (Daily data for week 44 through 5)
			Actual
			Call
	Week	Day	Volume
	44	Mon	988
	44	Tue	842
	44	Wed	601
	44	Thur	759
	44	Fri	687
	45	Mon	1,091
	45	Tue	1,042
	45	Wed	892
	45	Thur	840
	45	Fri	791
	46	Mon	1,303
	46	Tue	1,121
	46	Wed	1,003
	46	Thur	1,113
	46	Fri	998
	47	Mon	2,652
	47	Tue	2,825
	47	Wed	1,841
	47	Thur	1,851
	47	Fri	1,813
	48	Mon	1,949
	48	Tue	1,507
	48	Wed	989
	48	Thur	990
	48	Fri	1,084
	49	Mon	1,260
	49	Tue	1,134
	49	Wed	941
	49	Thur	847
	49	Fri	714
	50	Mon	1,002
	50	Tue	847
	50	Wed	922
	50	Thur	842
	50	Fri	784
	51	Mon	823
	51	Tue	756
	51	Wed	699
	51	Thur	401
	51	Fri	429
	52	Mon	1,209
	52	Tue	830
	52	Wed	852
	52	Thur	1,082
	52	Fri	841
	1	Mon	1,362
	1	Tue	1,174
	1	Wed	967
	1	Thur	930
	1	Fri	853
	2	Mon	924
	2	Tue	954
	2	Wed	1,346
	2	Thur	904
	2	Fri	758
	3	Mon	886
	3	Tue	878
	3	Wed	802
	3	Thur	945
	3	Fri	610
	4	Mon	941
	4	Tue	802
	4	Wed	705
	4	Thur	729
	4	Fri	772
	5	Mon	877
	5	Tue	722
	5	Wed	515
	5	Thur	584
	5	Fri	493

988 842 601 759 687 1091 1042 892 840 791 1303 1121 1003 1113 998 2652 2825 1841 1851 1813 1949 1507 989 990 1084 1260 1134 941 847 714 1002 847 922 842 784 823 756 699 401 429 1209 830 852 1082 841 1362 1174 967 930 853 924 954 1346 904 758 886 878 802 945 610 941 802 705 729 772 877 722 515 584 493

Seasonal Factors

Template for Seasonal Factors
			True			Range Name	Cells
	Week	Day	Value	Type of Seasonality		SeasonalFactor	G10:G21
	44	Mon		Daily		TrueValue	D5:D69
	44	Tue				TypeOfSeasonality	F5
	44	Wed
	44	Thur			Estimate for
	44	Fri		Day	Seasonal Factor
	45	Mon		Mon	1.2295
	45	Tue		Tue	1.0990
	45	Wed		Wed	0.9310
	45	Thur		Thur	0.9126
	45	Fri		Fri	0.828
	46	Mon
	46	Tue
	46	Wed
	46	Thur
	46	Fri
	47	Mon
	47	Tue
	47	Wed
	47	Thur
	47	Fri
	48	Mon
	48	Tue
	48	Wed
	48	Thur
	48	Fri
	49	Mon
	49	Tue
	49	Wed
	49	Thur
	49	Fri
	50	Mon
	50	Tue
	50	Wed
	50	Thur
	50	Fri
	51	Mon
	51	Tue
	51	Wed
	51	Thur
	51	Fri
	52	Mon
	52	Tue
	52	Wed
	52	Thur
	52	Fri
	1	Mon
	1	Tue
	1	Wed
	1	Thur
	1	Fri
	2	Mon
	2	Tue
	2	Wed
	2	Thur
	2	Fri
	3	Mon
	3	Tue
	3	Wed
	3	Thur
	3	Fri
	4	Mon
	4	Tue
	4	Wed
	4	Thur
	4	Fri
	5	Mon
	5	Tue
	5	Wed
	5	Thur
	5	Fri

Last Value

Template for Last-Value Forecasting Method with Seasonality
								Range Name	Cells
			True	Actual	Forecasting			ActualForecast	G6:G75
	Week	Day	Value	Forecast	Error			ForecastingError	H6:H75
	44	Mon	988			Mean Absolute Deviation		MAD	K23
	44	Tue	842	988	146	MAD =	203	MSE	K26
	44	Wed	601	842	241			SeasonalFactor	K9:K20
	44	Thu	759	601	158	Mean Square Error		SeasonallyAdjustedForecast	F6:F75
	44	Fri	687	759	72	MSE =	104,041	SeasonallyAdjustedValue	E6:E75
	45	Mon	1,091	687	404			TrueValue	D6:D75
	45	Tue	1,042	1,091	49			TypeOfSeasonality	K6
	45	Wed	892	1,042	150
	45	Thu	840	892	52
	45	Fri	791	840	49
	46	Mon	1,303	791	512
	46	Tue	1,121	1,303	182
	46	Wed	1,003	1,121	118
	46	Thu	1,113	1,003	110
	46	Fri	998	1,113	115
	47	Mon	2,652	998	1,654
	47	Tue	2,825	2,652	173
	47	Wed	1,841	2,825	984
	47	Thu	1,851	1,841	10
	47	Fri	1,813	1,851	38
	48	Mon	1,949	1,813	136
	48	Tue	1,507	1,949	442
	48	Wed	989	1,507	518
	48	Thu	990	989	1
	48	Fri	1,084	990	94
	49	Mon	1,260	1,084	176
	49	Tue	1,134	1,260	126
	49	Wed	941	1,134	193
	49	Thu	847	941	94
	49	Fri	714	847	133
	50	Mon	1,002	714	288
	50	Tue	847	1,002	155
	50	Wed	922	847	75
	50	Thu	842	922	80
	50	Fri	784	842	58
	51	Mon	823	784	39
	51	Tue	756	823	67
	51	Wed	699	756	57
	51	Thu	401	699	298
	51	Fri	429	401	28
	52	Mon	1,209	429	780
	52	Tue	830	1,209	379
	52	Wed	852	830	22
	52	Thu	1,082	852	230
	52	Fri	841	1,082	241
	1	Mon	1,362	841	521
	1	Tue	1,174	1,362	188
	1	Wed	967	1,174	207
	1	Thu	930	967	37
	1	Fri	853	930	77
	2	Mon	924	853	71
	2	Tue	954	924	30
	2	Wed	1,346	954	392
	2	Thu	904	1,346	442
	2	Fri	758	904	146
	3	Mon	886	758	128
	3	Tue	878	886	8
	3	Wed	802	878	76
	3	Thu	945	802	143
	3	Fri	610	945	335
	4	Mon	941	610	331
	4	Tue	802	941	139
	4	Wed	705	802	97
	4	Thu	729	705	24
	4	Fri	772	729	43
	5	Mon	877	772	105
	5	Tue	722	877	155
	5	Wed	515	722	207
	5	Thu	584	515	69
	5	Fri	493	584	91

1 #REF! 1 #REF!

Time Period

Seasonally-Adjusted Value

Last Value with Seasonality

Template for Last-Value Forecasting Method with Seasonality
				Seasonally	Seasonally					Range Name	Cells
			True	Adjusted	Adjusted	Actual	Forecasting			ActualForecast	G6:G75
	Week	Day	Value	Value	Forecast	Forecast	Error		Type of Seasonality	ForecastingError	H6:H75
	44	Mon	988	804					Daily	MAD	K23
	44	Tue	842	766	804	883	41			MSE	K26
	44	Wed	601	646	766	713	112	Day	Seasonal Factor	SeasonalFactor	K9:K20
	44	Thur	759	832	646	589	170	Mon	1.2295	SeasonallyAdjustedForecast	F6:F75
	44	Fri	687	830	832	689	2	Tue	1.0990	SeasonallyAdjustedValue	E6:E75
	45	Mon	1,091	887	830	1,020	71	Wed	0.9310	TrueValue	D6:D75
	45	Tue	1,042	948	887	975	67	Thur	0.9126	TypeOfSeasonality	K6
	45	Wed	892	958	948	883	9	Fri	0.8279
	45	Thur	840	920	958	874	34		1.053
	45	Fri	791	955	920	762	29		0.915
	46	Mon	1,303	1,060	955	1,175	128		0.908
	46	Tue	1,121	1,020	1,060	1,165	44		1.064
	46	Wed	1,003	1,077	1,020	950	53		1.041
	46	Thur	1,113	1,220	1,077	983	130		1.018
	46	Fri	998	1,205	1,220	1,010	12		0.884
	47	Mon	2,652	2,157	1,205	1,482	1,170
	47	Tue	2,825	2,571	2,157	2,370	455	Mean Absolute Deviation
	47	Wed	1,841	1,977	2,571	2,393	552	MAD =	159
	47	Thur	1,851	2,028	1,977	1,805	46
	47	Fri	1,813	2,190	2,028	1,679	134	Mean Square Error
	48	Mon	1,949	1,585	2,190	2,692	743	MSE =	64,847
	48	Tue	1,507	1,371	1,585	1,742	235
	48	Wed	989	1,062	1,371	1,277	288
	48	Thur	990	1,085	1,062	969	21
	48	Fri	1,084	1,309	1,085	898	186
	49	Mon	1,260	1,025	1,309	1,610	350
	49	Tue	1,134	1,032	1,025	1,126	8
	49	Wed	941	1,011	1,032	961	20
	49	Thur	847	928	1,011	922	75
	49	Fri	714	862	928	768	54
	50	Mon	1,002	815	862	1,060	58
	50	Tue	847	771	815	896	49
	50	Wed	922	990	771	718	204
	50	Thur	842	923	990	904	62
	50	Fri	784	947	923	764	20
	51	Mon	823	669	947	1,164	341
	51	Tue	756	688	669	736	20
	51	Wed	699	751	688	640	59
	51	Thur	401	439	751	685	284
	51	Fri	429	518	439	364	65
	52	Mon	1,209	983	518	637	572
	52	Tue	830	755	983	1,081	251
	52	Wed	852	915	755	703	149
	52	Thur	1,082	1,186	915	835	247
	52	Fri	841	1,016	1,186	982	141
	1	Mon	1,362	1,108	1,016	1,249	113
	1	Tue	1,174	1,068	1,108	1,217	43
	1	Wed	967	1,039	1,068	995	28
	1	Thur	930	1,019	1,039	948	18
	1	Fri	853	1,030	1,019	844	9
	2	Mon	924	752	1,030	1,267	343
	2	Tue	954	868	752	826	128
	2	Wed	1,346	1,446	868	808	538
	2	Thur	904	991	1,446	1,319	415
	2	Fri	758	916	991	820	62
	3	Mon	886	721	916	1,126	240
	3	Tue	878	799	721	792	86
	3	Wed	802	861	799	744	58
	3	Thur	945	1,035	861	786	159
	3	Fri	610	737	1,035	857	247
	4	Mon	941	765	737	906	35
	4	Tue	802	730	765	841	39
	4	Wed	705	757	730	679	26
	4	Thur	729	799	757	691	38
	4	Fri	772	932	799	661	111
	5	Mon	877	713	932	1,146	269
	5	Tue	722	657	664	730	8
	5	Wed	515	553	664	618	103
	5	Thur	584	640	664	606	22
	5	Fri	493	595	664	550	57

Seasonally Adjusted Value 803.58325128858519 766.16871841389138 645.54065009560225 831.6607630490754 829.81233336200216 887.35761857879186 948.15653751457819 958.10692160611859 920.41507373020204 955.43166767007824 1059.7864133897028 1020.0417260593495 1077.3332313575527 1219.5499726925177 1205.4624580717295 2156.9866218798866 2570.5779447972009 1977.4381644359464 2028.200358898338 2189.8832028898255 1585.2062315399317 1371.278216923675 1062.2956787762905 1084.7749083248809 1309.3399845187923 1024.812648404471 1031.8709343008941 1010.7383556405354 928.08519934462038 862.42504515352198 Seasonally Adjusted Forecast 803.58325128858519 766.16871841389138 645.54065009560225 831.6607630490754 829.81233336200216 887.35761857879186 948.15653751457819 958.10692160611859 920.41507373020204 955.43166767007824 1059.7864133897028 1020.0417260593495 1077.3332313575527 1219.5499726925177 1205.4624580717295 2156.9866218798866 2570.5779447972009 1977.4381644359464 2028.200358898338 2189.8832028898255 1585.2062315399317 1371.278216923675 1062.2956787762905 1084.7749083248809 1309.3399845187923 1024.812648404471 1031.8709343008941 1010.7383556405354 928.08519934462038

Time Period

Seasonally-Adjusted Value

Averaging with Seasonality

Template for Averaging Forecasting Method with Seasonality
				Seasonally	Seasonally					Range Name	Cells
			True	Adjusted	Adjusted	Actual	Forecasting			ActualForecast	G6:G75
	Week	Day	Value	Value	Forecast	Forecast	Error		Type of Seasonality	ForecastingError	H6:H75
	44	Mon	988	804					Daily	MAD	K23
	44	Tue	842	766	804	883	41			MSE	K26
	44	Wed	601	646	785	731	130	Day	Seasonal Factor	SeasonalFactor	K9:K20
	44	Thur	759	832	738	674	85	Mon	1.2295	SeasonallyAdjustedForecast	F6:F75
	44	Fri	687	830	762	631	56	Tue	1.0990	SeasonallyAdjustedValue	E6:E75
	45	Mon	1,091	887	775	953	138	Wed	0.9310	TrueValue	D6:D75
	45	Tue	1,042	948	794	873	169	Thur	0.9126	TypeOfSeasonality	K6
	45	Wed	892	958	816	760	132	Fri	0.8279
	45	Thur	840	920	834	761	79		1.000
	45	Fri	791	955	843	698	93		1.000
	46	Mon	1,303	1,060	855	1,051	252		1.000
	46	Tue	1,121	1,020	873	960	161		1.000
	46	Wed	1,003	1,077	886	824	179		1.000
	46	Thur	1,113	1,220	900	822	291		1.000
	46	Fri	998	1,205	923	764	234		1.000
	47	Mon	2,652	2,157	942	1,158	1,494
	47	Tue	2,825	2,571	1,018	1,119	1,706	Mean Absolute Deviation
	47	Wed	1,841	1,977	1,109	1,033	808	MAD =	299
	47	Thur	1,851	2,028	1,157	1,056	795
	47	Fri	1,813	2,190	1,203	996	817	Mean Square Error
	48	Mon	1,949	1,585	1,253	1,540	409	MSE =	175,224
	48	Tue	1,507	1,371	1,268	1,394	113
	48	Wed	989	1,062	1,273	1,185	196
	48	Thur	990	1,085	1,264	1,153	163
	48	Fri	1,084	1,309	1,256	1,040	44
	49	Mon	1,260	1,025	1,259	1,547	287
	49	Tue	1,134	1,032	1,250	1,373	239
	49	Wed	941	1,011	1,242	1,156	215
	49	Thur	847	928	1,233	1,126	279
	49	Fri	714	862	1,223	1,012	298
	50	Mon	1,002	815	1,211	1,489	487
	50	Tue	847	771	1,198	1,317	470
	50	Wed	922	990	1,185	1,103	181
	50	Thur	842	923	1,179	1,076	234
	50	Fri	784	947	1,171	970	186
	51	Mon	823	669	1,165	1,432	609
	51	Tue	756	688	1,151	1,265	509
	51	Wed	699	751	1,139	1,060	361
	51	Thur	401	439	1,128	1,030	629
	51	Fri	429	518	1,111	920	491
	52	Mon	1,209	983	1,096	1,347	138
	52	Tue	830	755	1,093	1,201	371
	52	Wed	852	915	1,085	1,010	158
	52	Thur	1,082	1,186	1,081	987	95
	52	Fri	841	1,016	1,083	897	56
	1	Mon	1,362	1,108	1,082	1,330	32
	1	Tue	1,174	1,068	1,083	1,190	16
	1	Wed	967	1,039	1,082	1,008	41
	1	Thur	930	1,019	1,081	987	57
	1	Fri	853	1,030	1,080	894	41
	2	Mon	924	752	1,079	1,327	403
	2	Tue	954	868	1,073	1,179	225
	2	Wed	1,346	1,446	1,069	995	351
	2	Thur	904	991	1,076	982	78
	2	Fri	758	916	1,074	889	131
	3	Mon	886	721	1,071	1,317	431
	3	Tue	878	799	1,065	1,171	293
	3	Wed	802	861	1,060	987	185
	3	Thur	945	1,035	1,057	965	20
	3	Fri	610	737	1,057	875	265
	4	Mon	941	765	1,051	1,293	352
	4	Tue	802	730	1,047	1,150	348
	4	Wed	705	757	1,041	970	265
	4	Thur	729	799	1,037	946	217
	4	Fri	772	932	1,033	855	83
	5	Mon	877	713	1,032	1,268	391
	5	Tue	722	657	1,027	1,129	407
	5	Wed	515	553	1,021	951	436
	5	Thur	584	640	1,014	926	342
	5	Fri	493	595	1,009	835	342

Seasonally Adjusted Value 803.58325128858519 766.16871841389138 645.54065009560225 831.6607630490754 829.81233336200216 887.35761857879186 948.15653751457819 958.10692160611859 920.41507373020204 955.43166767007824 1059.7864133897028 1020.0417260593495 1077.3332313575527 1219.5499726925177 1205.4624580717295 2156.9866218798866 2570.5779447972009 1977.4381644359464 2028.200358898338 2189.8832028898255 1585.2062315399317 1371.278216923675 1062.2956787762905 1084.7749083248809 1309.3399845187923 1024.812648404471 1031.8709343008941 1010.7383556405354 928.08519934462038 862.42504515352198 Seasonally Adjusted Forecast 803.58325128858519 784.87598485123829 738.4308732660262 761.7383457117885 775.35314324183128 794.02055579799128 816.03998175750371 833.79834923858061 843.42242973764974 854.62335353089259 873.27454079078427 885.50513956316479 900.26114662427142 923.06749134343193 941.8938224586517 1017.837122422479 1109.1748178562862 1157.4116704440448 1203.2426540469025 1252.5746814890485 1268.4142791105191 1273.0899126474808 1263.9249459574291 1256.460361056073 1258.5755459945817 1249.584665318039 1241.5211937988856 1233.2789495789443 1222.755027157071

Time Period

Seasonally-Adjusted Value

Moving Average with Seasonality

Template for Moving-Average Forecasting Method with Seasonality
				Seasonally	Seasonally					Range Name	Cells
			True	Adjusted	Adjusted	Actual	Forecasting	Number of previous		ActualForecast	G6:G75
	Week	Day	Value	Value	Forecast	Forecast	Error	periods to consider		ForecastingError	H6:H75
	44	Mon	988	804				n =	5	MAD	K26
	44	Tue	842	766	ERROR:#N/A					MSE	K29
	44	Wed	601	646	ERROR:#N/A				Type of Seasonality	NumberOfPeriods	K6
	44	Thur	759	832	ERROR:#N/A				Daily	SeasonalFactor	K12:K23
	44	Fri	687	830	ERROR:#N/A					SeasonallyAdjustedForecast	F6:F75
	45	Mon	1,091	887	775	953	138	Day	Seasonal Factor	SeasonallyAdjustedValue	E6:E75
	45	Tue	1,042	948	792	871	171	Mon	1.2295	TrueValue	D6:D75
	45	Wed	892	958	829	771	121	Tue	1.0990	TypeOfSeasonality	K9
	45	Thur	840	920	891	813	27	Wed	0.9310
	45	Fri	791	955	909	752	39	Thur	0.9126
	46	Mon	1,303	1,060	934	1,148	155	Fri	0.8279
	46	Tue	1,121	1,020	968	1,064	57		1.000
	46	Wed	1,003	1,077	983	915	88		1.000
	46	Thur	1,113	1,220	1,007	919	194		1.000
	46	Fri	998	1,205	1,066	883	115		1.000
	47	Mon	2,652	2,157	1,116	1,373	1,279		1.000
	47	Tue	2,825	2,571	1,336	1,468	1,357		1.000
	47	Wed	1,841	1,977	1,646	1,532	309		1.000
	47	Thur	1,851	2,028	1,826	1,666	185
	47	Fri	1,813	2,190	1,988	1,646	167	Mean Absolute Deviation
	48	Mon	1,949	1,585	2,185	2,686	737	MAD =	221
	48	Tue	1,507	1,371	2,070	2,275	768
	48	Wed	989	1,062	1,830	1,704	715	Mean Square Error
	48	Thur	990	1,085	1,647	1,503	513	MSE =	114,286
	48	Fri	1,084	1,309	1,459	1,208	124
	49	Mon	1,260	1,025	1,283	1,577	317
	49	Tue	1,134	1,032	1,171	1,286	152
	49	Wed	941	1,011	1,103	1,027	86
	49	Thur	847	928	1,092	997	150
	49	Fri	714	862	1,061	878	164
	50	Mon	1,002	815	972	1,195	193
	50	Tue	847	771	930	1,022	175
	50	Wed	922	990	877	817	105
	50	Thur	842	923	873	797	45
	50	Fri	784	947	872	722	62
	51	Mon	823	669	889	1,093	270
	51	Tue	756	688	860	945	189
	51	Wed	699	751	843	785	86
	51	Thur	401	439	796	726	325
	51	Fri	429	518	699	579	150
	52	Mon	1,209	983	613	754	455
	52	Tue	830	755	676	743	87
	52	Wed	852	915	689	642	210
	52	Thur	1,082	1,186	722	659	423
	52	Fri	841	1,016	871	722	119
	1	Mon	1,362	1,108	971	1,194	168
	1	Tue	1,174	1,068	996	1,094	80
	1	Wed	967	1,039	1,059	985	18
	1	Thur	930	1,019	1,083	989	59
	1	Fri	853	1,030	1,050	869	16
	2	Mon	924	752	1,053	1,294	370
	2	Tue	954	868	982	1,079	125
	2	Wed	1,346	1,446	942	877	469
	2	Thur	904	991	1,023	934	30
	2	Fri	758	916	1,017	842	84
	3	Mon	886	721	994	1,222	336
	3	Tue	878	799	988	1,086	208
	3	Wed	802	861	974	907	105
	3	Thur	945	1,035	857	783	162
	3	Fri	610	737	866	717	107
	4	Mon	941	765	831	1,021	80
	4	Tue	802	730	840	923	121
	4	Wed	705	757	826	769	64
	4	Thur	729	799	805	735	6
	4	Fri	772	932	758	627	145
	5	Mon	877	713	797	980	103
	5	Tue	722	657	786	864	142
	5	Wed	515	553	772	719	204
	5	Thur	584	640	731	667	83
	5	Fri	493	595	699	579	86

Seasonally Adjusted Value 803.58325128858519 766.16871841389138 645.54065009560225 831.6607630490754 829.81233336200216 887.35761857879186 948.15653751457819 958.10692160611859 920.41507373020204 955.43166767007824 1059.7864133897028 1020.0417260593495 1077.3332313575527 1219.5499726925177 1205.4624580717295 2156.9866218798866 2570.5779447972009 1977.4381644359464 2028.200358898338 2189.8832028898255 1585.2062315399317 1371.278216923675 1062.2956787762905 1084.7749083248809 1309.3399845187923 1024.812648404471 1031.8709343008941 1010.7383556405354 928.08519934462038 862.42504515352198 Seasonally Adjusted Forecast #N/A #N/A #N/A #N/A 775.35314324183128 792.10801669987256 828.50558052000997 891.01883482211326 908.76969695833873 933.8935638199539 968.37932278213589 982.75636049109016 1006.601622441377 1066.4286022338401 1116.4347603141705 1335.8748020122071 1645.9820457597773 1826.0030323754563 1987.7331096166204 2184.6172585802392 2070.2611805122483 1830.4012349375432 1647.3727378056124 1458.6876476909206 1282.5790040167142 1170.5002873896221 1102.6188308650658 1092.3073662379147 1060.9694244418627

Time Period

Seasonally-Adjusted Value

Expon Smoothing wSeason (lo)

Template for Exponential Smoothing Forecasting Method with Seasonality
				Seasonally	Seasonally					Range Name	Cells
			True	Adjusted	Adjusted	Actual	Forecasting	Smoothing Constant		ActualForecast	G6:G75
	Week	Day	Value	Value	Forecast	Forecast	Error	a =	0.2	Alpha	K5
	44	Mon	988	804	900	1,107	119			ForecastingError	H6:H75
	44	Tue	842	766	881	968	126	Initial Estimate		InitialEstimate	K8
	44	Wed	601	646	858	799	198	Average =	900	MAD	K28
	44	Thur	759	832	815	744	15			MSE	K31
	44	Fri	687	830	819	678	9		Type of Seasonality	SeasonalFactor	K14:K25
	45	Mon	1,091	887	821	1,009	82		Daily	SeasonallyAdjustedForecast	F6:F75
	45	Tue	1,042	948	834	917	125			SeasonallyAdjustedValue	E6:E75
	45	Wed	892	958	857	798	94	Day	Seasonal Factor	TrueValue	D6:D75
	45	Thur	840	920	877	801	39	Mon	1.2295	TypeOfSeasonality	K11
	45	Fri	791	955	886	733	58	Tue	1.0990
	46	Mon	1,303	1,060	900	1,106	197	Wed	0.9310
	46	Tue	1,121	1,020	932	1,024	97	Thur	0.9126
	46	Wed	1,003	1,077	949	884	119	Fri	0.8279
	46	Thur	1,113	1,220	975	890	223		1.000
	46	Fri	998	1,205	1,024	848	150		1.000
	47	Mon	2,652	2,157	1,060	1,304	1,348		1.000
	47	Tue	2,825	2,571	1,280	1,406	1,419		1.000
	47	Wed	1,841	1,977	1,538	1,432	409		1.000
	47	Thur	1,851	2,028	1,626	1,484	367		1.000
	47	Fri	1,813	2,190	1,706	1,413	400		1.000
	48	Mon	1,949	1,585	1,803	2,217	268
	48	Tue	1,507	1,371	1,759	1,934	427	Mean Absolute Deviation
	48	Wed	989	1,062	1,682	1,566	577	MAD =	224
	48	Thur	990	1,085	1,558	1,422	432
	48	Fri	1,084	1,309	1,463	1,211	127	Mean Square Error
	49	Mon	1,260	1,025	1,432	1,761	501	MSE =	108,520
	49	Tue	1,134	1,032	1,351	1,485	351
	49	Wed	941	1,011	1,287	1,198	257
	49	Thur	847	928	1,232	1,124	277
	49	Fri	714	862	1,171	970	256
	50	Mon	1,002	815	1,109	1,364	362
	50	Tue	847	771	1,050	1,154	307
	50	Wed	922	990	995	926	4
	50	Thur	842	923	994	907	65
	50	Fri	784	947	979	811	27
	51	Mon	823	669	973	1,196	373
	51	Tue	756	688	912	1,003	247
	51	Wed	699	751	867	808	109
	51	Thur	401	439	844	770	369
	51	Fri	429	518	763	632	203
	52	Mon	1,209	983	714	878	331
	52	Tue	830	755	768	844	14
	52	Wed	852	915	765	713	139
	52	Thur	1,082	1,186	795	726	356
	52	Fri	841	1,016	873	723	118
	1	Mon	1,362	1,108	902	1,109	253
	1	Tue	1,174	1,068	943	1,036	138
	1	Wed	967	1,039	968	901	66
	1	Thur	930	1,019	982	896	34
	1	Fri	853	1,030	990	819	34
	2	Mon	924	752	998	1,227	303
	2	Tue	954	868	948	1,042	88
	2	Wed	1,346	1,446	932	868	478
	2	Thur	904	991	1,035	945	41
	2	Fri	758	916	1,026	850	92
	3	Mon	886	721	1,004	1,234	348
	3	Tue	878	799	947	1,041	163
	3	Wed	802	861	918	854	52
	3	Thur	945	1,035	906	827	118
	3	Fri	610	737	932	772	162
	4	Mon	941	765	893	1,098	157
	4	Tue	802	730	868	953	151
	4	Wed	705	757	840	782	77
	4	Thur	729	799	823	752	23
	4	Fri	772	932	819	678	94
	5	Mon	877	713	841	1,034	157
	5	Tue	722	657	816	896	174
	5	Wed	515	553	784	730	215
	5	Thur	584	640	738	673	89
	5	Fri	493	595	718	595	102

Seasonally Adjusted Value 803.58325128858519 766.16871841389138 645.54065009560225 831.6607630490754 829.81233336200216 887.35761857879186 948.15653751457819 958.10692160611859 920.41507373020204 955.43166767007824 1059.7864133897028 1020.0417260593495 1077.3332313575527 1219.5499726925177 1205.4624580717295 2156.9866218798866 2570.5779447972009 1977.4381644359464 2028.200358898338 2189.8832028898255 1585.2062315399317 1371.278216923675 1062.2956787762905 1084.7749083248809 1309.3399845187923 1024.812648404471 1031.8709343008941 1010.7383556405354 928.08519934462038 862.42504515352198 Seasonally Adjusted Forecast 900 880.71665025771699 857.80706388895192 815.35378113028207 818.61517751404085 820.85460868363316 834.15521066266501 856.95547603304772 877.18576514766187 885.83162686416995 899.75163502535167 931.75859069822195 949.4152177704475 974.99882048786856 1023.9090509287985 1060.2197323573846 1279.5731102618852 1537.7740771689482 1625.706894622348 1706.205587477546 1802.941110560002 1759.394134755988 1681.7709511895257 1557.8758967068788 1463.2556990304795 1432.4725561281421 1350.9405745834079 1287.126646526905 1231.8489883496311 1171.0962305486291

Time Period

Seasonally-Adjusted Value

Expon Smoothing wSeason (hi)

Template for Exponential Smoothing Forecasting Method with Seasonality
				Seasonally	Seasonally					Range Name	Cells
			True	Adjusted	Adjusted	Actual	Forecasting	Smoothing Constant		ActualForecast	G6:G75
	Week	Day	Value	Value	Forecast	Forecast	Error	a =	0.9	Alpha	K5
	44	Mon	988	804	900	1,107	119			ForecastingError	H6:H75
	44	Tue	842	766	813	894	52	Initial Estimate		InitialEstimate	K8
	44	Wed	601	646	771	718	117	Average =	900	MAD	K28
	44	Thur	759	832	658	601	158			MSE	K31
	44	Fri	687	830	814	674	13		Type of Seasonality	SeasonalFactor	K14:K25
	45	Mon	1,091	887	828	1,018	73		Daily	SeasonallyAdjustedForecast	F6:F75
	45	Tue	1,042	948	881	969	73			SeasonallyAdjustedValue	E6:E75
	45	Wed	892	958	941	877	15	Day	Seasonal Factor	TrueValue	D6:D75
	45	Thur	840	920	956	873	33	Mon	1.2295	TypeOfSeasonality	K11
	45	Fri	791	955	924	765	26	Tue	1.0990
	46	Mon	1,303	1,060	952	1,171	132	Wed	0.9310
	46	Tue	1,121	1,020	1,049	1,153	32	Thur	0.9126
	46	Wed	1,003	1,077	1,023	952	51	Fri	0.8279
	46	Thur	1,113	1,220	1,072	978	135		1.000
	46	Fri	998	1,205	1,205	997	1		1.000
	47	Mon	2,652	2,157	1,205	1,482	1,170		1.000
	47	Tue	2,825	2,571	2,062	2,266	559		1.000
	47	Wed	1,841	1,977	2,520	2,346	505		1.000
	47	Thur	1,851	2,028	2,032	1,854	3		1.000
	47	Fri	1,813	2,190	2,029	1,679	134		1.000
	48	Mon	1,949	1,585	2,174	2,673	724
	48	Tue	1,507	1,371	1,644	1,807	300	Mean Absolute Deviation
	48	Wed	989	1,062	1,399	1,302	313	MAD =	157
	48	Thur	990	1,085	1,096	1,000	10
	48	Fri	1,084	1,309	1,086	899	185	Mean Square Error
	49	Mon	1,260	1,025	1,287	1,582	322	MSE =	63,929
	49	Tue	1,134	1,032	1,051	1,155	21
	49	Wed	941	1,011	1,034	962	21
	49	Thur	847	928	1,013	925	78
	49	Fri	714	862	937	775	61
	50	Mon	1,002	815	870	1,069	67
	50	Tue	847	771	820	902	55
	50	Wed	922	990	776	722	200
	50	Thur	842	923	969	884	42
	50	Fri	784	947	927	768	16
	51	Mon	823	669	945	1,162	339
	51	Tue	756	688	697	766	10
	51	Wed	699	751	689	641	58
	51	Thur	401	439	745	680	279
	51	Fri	429	518	470	389	40
	52	Mon	1,209	983	513	631	578
	52	Tue	830	755	936	1,029	199
	52	Wed	852	915	773	720	132
	52	Thur	1,082	1,186	901	822	260
	52	Fri	841	1,016	1,157	958	117
	1	Mon	1,362	1,108	1,030	1,266	96
	1	Tue	1,174	1,068	1,100	1,209	35
	1	Wed	967	1,039	1,071	998	31
	1	Thur	930	1,019	1,042	951	21
	1	Fri	853	1,030	1,021	846	7
	2	Mon	924	752	1,029	1,266	342
	2	Tue	954	868	779	856	98
	2	Wed	1,346	1,446	859	800	546
	2	Thur	904	991	1,387	1,266	362
	2	Fri	758	916	1,030	853	95
	3	Mon	886	721	927	1,140	254
	3	Tue	878	799	741	815	63
	3	Wed	802	861	793	738	64
	3	Thur	945	1,035	855	780	165
	3	Fri	610	737	1,017	842	232
	4	Mon	941	765	765	940	1
	4	Tue	802	730	765	841	39
	4	Wed	705	757	733	683	22
	4	Thur	729	799	755	689	40
	4	Fri	772	932	794	658	114
	5	Mon	877	713	919	1,130	253
	5	Tue	722	657	734	806	84
	5	Wed	515	553	665	619	104
	5	Thur	584	640	564	515	69
	5	Fri	493	595	632	524	31

Seasonally Adjusted Value 803.58325128858519 766.16871841389138 645.54065009560225 831.6607630490754 829.81233336200216 887.35761857879186 948.15653751457819 958.10692160611859 920.41507373020204 955.43166767007824 1059.7864133897028 1020.0417260593495 1077.3332313575527 1219.5499726925177 1205.4624580717295 2156.9866218798866 2570.5779447972009 1977.4381644359464 2028.200358898338 2189.8832028898255 1585.2062315399317 1371.278216923675 1062.2956787762905 1084.7749083248809 1309.3399845187923 1024.812648404471 1031.8709343008941 1010.7383556405354 928.08519934462038 862.42504515352198 Seasonally Adjusted Forecast 900 813.22492615972669 770.87433918847501 658.07401900488958 814.30208864465681 828.26130889026763 881.44798760993945 941.48568252411428 956.44479769791815 924.01804612697367 952.29030551576773 1049.0368026023093 1022.9412337136454 1071.894031593162 1204.7843785825823 1205.3946501228149 2061.8274247041795 2519.7028927878987 2031.6646372711416 2028.5467867356185 2173.7495612744046 1644.0605645133789 1398.5564516826455 1095.921756066926 1085.8895930990855 1286.9949453768215 1051.0308781017061 1033.7869286809753 1013.0432129445793 936.58100070461637

Time Period

Seasonally-Adjusted Value

Sheet1

			Forecast
Week	Day	Actual Value	Last Value	Last Value w Seasonal	Averaging	Moving Average	Exponential Smoothing (lo)	Exponential Smoothing (hi)
5	Mon	877	877	932	1,032	797	841	919
5	Tue	722	722	664	1,027	786	816	734
5	Wed	515	515	664	1,021	772	784	665
5	Thur	584	584	664	1,014	731	738	564
5	Fri	493	493	664	1,009	699	718	632
	MAD		202.7	158.8	299.0	221.4	224.3	157.0