0 05 unless otherwise specified For each problem please do the following in addition to anything the individual problem asks Observe and describe the basic nature of the series in question Fit an appropriate model for the series Determine adequacy of model to fit data and assess validity of selected model Forecast response for requested time interval(s) Daily Demand XLS Use the data provided to create an acceptable model to forecast the target(total orders) Week of the month (first week, Day of the week (Monday to Frid Non urgent order Urgent order Order type A Order type B Order type C Fiscal sector orders Orders from the traffic control Banking orders (1) Banking orders (2) Banking orders (3) Target (Total orders) 1 4 316 307 223 27 61 543 175 586 302 448 0 65556 44914 188411 14793 539 577 1 5 128 633 96 042 38 058 56 037 130 58 0 40419 21399 89461 7679 224 675 1 6 43 651 84 375 21 826 25 125 82 461 1 386 11992 3452 21305 14947 129 412 2 2 171 297 127 667 41 542 113 294 162 284 18 156 49971 33703 69054 18423 317 12 2 3 90 532 113 526 37 679 56 618 116 22 6 459 48534 19646 16411 20257 210 517 2 4 110 925 96 36 30 792 50 704 125 868 79 52042 8773 47522 24966 207 364 2 5 144 124 118 919 43 304 66 371 153 368 0 46573 33597 48269 20973 263 043 2 6 119 379 113 87 38 584 85 961 124 413 15 709 35033 26278 56665 18502 248 958 3 2 218 856 124 381 33 973 148 274 162 044 1 054 66612 19461 103376 10458 344 291 3 3 146 518 101 045 36 399 43 306 168 723 865 58224 7742 82395 11948 248 428 3 4 178 433 102 793 45 706 111 036 124 678 194 47046 17299 108719 15560 281 42 3 5 145 865 91 18 43 851 66 277 133 44 6 523 66910 17768 36693 29046 243 568 3 6 170 566 114 412 43 339 136 434 128 405 23 2 32529 34002 78153 31949 308 178 4 2 220 343 141 406 46 241 120 865 196 296 1 653 34878 32905 117137 29188 363 402 4 3 193 768 141 854 56 519 136 709 143 644 1 25 57858 23956 101048 30134 336 872 4 4 122 736 124 256 56 167 78 101 112 724 0 52321 10046 62799 24233 246 992 4 5 144 051 158 408 51 66 92 272 164 948 6 421 47167 6440 91784 15973 308 88 4 6 105 415 108 688 47 717 71 474 113 935 19 023 42737 26020 27873 17600 233 126 5 2 240 66 163 72 59 135 157 681 187 564 0 39273 32917 155617 9203 404 38 1 3 131 067 166 649 90 476 80 509 127 575 844 60543 19141 78378 73839 298 56 1 4 130 129 98 927 42 904 43 962 142 383 193 54760 9163 29874 46992 229 249 1 5 123 286 103 551 47 331 72 444 116 529 9 467 48732 21196 47793 47574 236 304 1 6 190 816 87 629 32 077 127 358 137 739 18 729 46368 36798 92701 31098 297 174 2 2 266 741 141 437 58 721 139 034 211 646 1 223 58081 43333 135314 29716 409 401 2 3 123 143 106 083 36 017 75 813 119 205 1 809 45340 22109 55584 29803 231 035 2 4 148 139 85 31 35 576 79 997 123 253 5 377 59686 14188 67617 32319 238 826 2 5 118 552 100 417 54 401 75 613 105 584 16 629 40423 24682 47563 35314 235 598 2 6 146 959 95 153 37 656 59 907 144 549 0 50908 45733 43930 28998 242 112 3 2 299 77 133 375 57 81 236 248 196 732 57 645 71772 57756 159373 29160 490 79 3 3 151 341 131 788 43 359 89 382 156 916 6 528 53573 42638 62732 32386 289 657 3 4 206 206 92 16 45 555 148 718 104 186 93 49110 36904 126632 33237 298 459 3 5 170 868 131 463 45 55 120 548 157 505 21 272 42534 79556 50433 36483 323 603 4 3 435 304 181 149 67 884 267 342 281 227 0 64867 210508 177229 30514 616 453 4 4 235 106 110 874 70 376 154 242 121 417 55 23257 163452 63699 33805 346 035 4 5 168 179 125 119 71 068 100 544 136 033 14 347 28072 95989 50763 55445 307 645 4 6 172 783 77 371 64 137 109 062 80 648 3 693 46321 66498 61593 31625 253 847 5 2 381 768 140 041 118 178 260 632 152 134 9 135 34236 194216 136035 47601 530 944 5 3 221 438 111 392 51 199 124 66 157 5 529 39964 136119 66745 31031 333 359 5 4 193 957 111 859 47 002 99 892 159 462 540 59179 94460 54772 34616 306 356 1 6 275 076 121 697 109 888 131 165 175 777 20 057 37906 138536 85378 14020 416 83 2 2 252 298 150 708 77 388 154 863 182 936 12 181 32133 69093 169088 12516 415 187 2 3 165 472 102 53 46 295 96 87 124 837 0 48458 43112 72840 11304 268 002 2 4 126 03 108 055 53 366 69 15 111 987 418 42201 13736 70191 16710 234 503 2 5 112 246 106 641 47 399 77 61 109 715 15 837 35316 25876 38646 13989 234 724 2 6 123 302 94 315 48 081 72 826 109 157 12 447 43284 30138 52112 12632 230 064 3 2 187 81 167 455 59 042 130 098 168 254 2 129 37817 36445 103567 10443 357 394 3 3 119 863 139 383 44 809 99 072 115 365 0 54584 17242 59231 12543 259 246 3 4 127 805 114 813 39 025 110 74 94 47 1 617 33366 21103 84558 16683 244 235 3 5 120 629 112 703 39 6 240 922 122 085 169 275 37387 20246 63778 13886 402 607 3 6 130 465 105 273 57 467 88 462 109 132 19 323 27200 41713 59513 12260 255 061 4 2 222 282 120 324 41 418 135 189 165 999 0 39446 29290 154144 10811 342 606 4 3 150 257 116 959 34 193 115 536 118 911 1 424 51346 19782 89704 12182 268 64 4 4 96 494 87 294 32 653 81 576 74 372 4 813 34631 22420 49644 15390 188 601 4 5 89 526 99 756 51 985 51 93 98 107 12 74 31850 32150 21573 13807 202 022 4 6 134 425 79 084 36 748 71 353 105 408 0 33970 28701 65199 11023 213 509 5 2 158 716 158 133 59 131 92 639 165 079 0 32027 33282 128269 9287 316 849 5 3 150 784 133 069 54 224 115 746 116 442 2 559 51235 34421 87708 11354 286 412 5 4 193 534 109 639 58 378 142 382 102 687 274 28364 88404 91367 15003 303 447 5 5 196 555 108 395 76 763 96 478 131 709 0 37011 109931 50112 12957 304 95 5 6 192 116 121 106 107 568 121 152 103 18 18 678 27328 108072 56015 10690 331 9

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 20, 2020

=0.05 unless otherwise specified. For each problem please do the following in addition to anything the individual problem asks: Observe and describe the basic nature

α=0.05 unless otherwise specified.
For each problem please do the following in addition to anything the individual problem asks:
Observe and describe the basic nature of the series in question
Fit an appropriate model for the series
Determine adequacy of model to fit data and assess validity of selected model
Forecast response for requested time interval(s)
Daily Demand.XLS: Use the data provided to create an acceptable model to forecast the target(total orders).

Week of the month (first week,	Day of the week (Monday to Frid	Non-urgent order	Urgent order	Order type A	Order type B	Order type C	Fiscal sector orders	Orders from the traffic control	Banking orders (1)	Banking orders (2)	Banking orders (3)	Target (Total orders)
1	4	316.307	223.27	61.543	175.586	302.448	0	65556	44914	188411	14793	539.577
1	5	128.633	96.042	38.058	56.037	130.58	0	40419	21399	89461	7679	224.675
1	6	43.651	84.375	21.826	25.125	82.461	1.386	11992	3452	21305	14947	129.412
2	2	171.297	127.667	41.542	113.294	162.284	18.156	49971	33703	69054	18423	317.12
2	3	90.532	113.526	37.679	56.618	116.22	6.459	48534	19646	16411	20257	210.517
2	4	110.925	96.36	30.792	50.704	125.868	79	52042	8773	47522	24966	207.364
2	5	144.124	118.919	43.304	66.371	153.368	0	46573	33597	48269	20973	263.043
2	6	119.379	113.87	38.584	85.961	124.413	15.709	35033	26278	56665	18502	248.958
3	2	218.856	124.381	33.973	148.274	162.044	1.054	66612	19461	103376	10458	344.291
3	3	146.518	101.045	36.399	43.306	168.723	865	58224	7742	82395	11948	248.428
3	4	178.433	102.793	45.706	111.036	124.678	194	47046	17299	108719	15560	281.42
3	5	145.865	91.18	43.851	66.277	133.44	6.523	66910	17768	36693	29046	243.568
3	6	170.566	114.412	43.339	136.434	128.405	23.2	32529	34002	78153	31949	308.178
4	2	220.343	141.406	46.241	120.865	196.296	1.653	34878	32905	117137	29188	363.402
4	3	193.768	141.854	56.519	136.709	143.644	1.25	57858	23956	101048	30134	336.872
4	4	122.736	124.256	56.167	78.101	112.724	0	52321	10046	62799	24233	246.992
4	5	144.051	158.408	51.66	92.272	164.948	6.421	47167	6440	91784	15973	308.88
4	6	105.415	108.688	47.717	71.474	113.935	19.023	42737	26020	27873	17600	233.126
5	2	240.66	163.72	59.135	157.681	187.564	0	39273	32917	155617	9203	404.38
1	3	131.067	166.649	90.476	80.509	127.575	844	60543	19141	78378	73839	298.56
1	4	130.129	98.927	42.904	43.962	142.383	193	54760	9163	29874	46992	229.249
1	5	123.286	103.551	47.331	72.444	116.529	9.467	48732	21196	47793	47574	236.304
1	6	190.816	87.629	32.077	127.358	137.739	18.729	46368	36798	92701	31098	297.174
2	2	266.741	141.437	58.721	139.034	211.646	1.223	58081	43333	135314	29716	409.401
2	3	123.143	106.083	36.017	75.813	119.205	1.809	45340	22109	55584	29803	231.035
2	4	148.139	85.31	35.576	79.997	123.253	5.377	59686	14188	67617	32319	238.826
2	5	118.552	100.417	54.401	75.613	105.584	16.629	40423	24682	47563	35314	235.598
2	6	146.959	95.153	37.656	59.907	144.549	0	50908	45733	43930	28998	242.112
3	2	299.77	133.375	57.81	236.248	196.732	57.645	71772	57756	159373	29160	490.79
3	3	151.341	131.788	43.359	89.382	156.916	6.528	53573	42638	62732	32386	289.657
3	4	206.206	92.16	45.555	148.718	104.186	93	49110	36904	126632	33237	298.459
3	5	170.868	131.463	45.55	120.548	157.505	21.272	42534	79556	50433	36483	323.603
4	3	435.304	181.149	67.884	267.342	281.227	0	64867	210508	177229	30514	616.453
4	4	235.106	110.874	70.376	154.242	121.417	55	23257	163452	63699	33805	346.035
4	5	168.179	125.119	71.068	100.544	136.033	14.347	28072	95989	50763	55445	307.645
4	6	172.783	77.371	64.137	109.062	80.648	3.693	46321	66498	61593	31625	253.847
5	2	381.768	140.041	118.178	260.632	152.134	9.135	34236	194216	136035	47601	530.944
5	3	221.438	111.392	51.199	124.66	157.5	529	39964	136119	66745	31031	333.359
5	4	193.957	111.859	47.002	99.892	159.462	540	59179	94460	54772	34616	306.356
1	6	275.076	121.697	109.888	131.165	175.777	20.057	37906	138536	85378	14020	416.83
2	2	252.298	150.708	77.388	154.863	182.936	12.181	32133	69093	169088	12516	415.187
2	3	165.472	102.53	46.295	96.87	124.837	0	48458	43112	72840	11304	268.002
2	4	126.03	108.055	53.366	69.15	111.987	418	42201	13736	70191	16710	234.503
2	5	112.246	106.641	47.399	77.61	109.715	15.837	35316	25876	38646	13989	234.724
2	6	123.302	94.315	48.081	72.826	109.157	12.447	43284	30138	52112	12632	230.064
3	2	187.81	167.455	59.042	130.098	168.254	2.129	37817	36445	103567	10443	357.394
3	3	119.863	139.383	44.809	99.072	115.365	0	54584	17242	59231	12543	259.246
3	4	127.805	114.813	39.025	110.74	94.47	1.617	33366	21103	84558	16683	244.235
3	5	120.629	112.703	39.6	240.922	122.085	169.275	37387	20246	63778	13886	402.607
3	6	130.465	105.273	57.467	88.462	109.132	19.323	27200	41713	59513	12260	255.061
4	2	222.282	120.324	41.418	135.189	165.999	0	39446	29290	154144	10811	342.606
4	3	150.257	116.959	34.193	115.536	118.911	1.424	51346	19782	89704	12182	268.64
4	4	96.494	87.294	32.653	81.576	74.372	4.813	34631	22420	49644	15390	188.601
4	5	89.526	99.756	51.985	51.93	98.107	12.74	31850	32150	21573	13807	202.022
4	6	134.425	79.084	36.748	71.353	105.408	0	33970	28701	65199	11023	213.509
5	2	158.716	158.133	59.131	92.639	165.079	0	32027	33282	128269	9287	316.849
5	3	150.784	133.069	54.224	115.746	116.442	2.559	51235	34421	87708	11354	286.412
5	4	193.534	109.639	58.378	142.382	102.687	274	28364	88404	91367	15003	303.447
5	5	196.555	108.395	76.763	96.478	131.709	0	37011	109931	50112	12957	304.95
5	6	192.116	121.106	107.568	121.152	103.18	18.678	27328	108072	56015	10690	331.9

Step by Step Solution

★★★★★

3.40 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

Observation and Description The data is a daily demand series that consists of 13 predictors and one target variable total orders The predictors include Week of the Month Day of the Week NonUrgent ord... blur-text-image