Please copy and paste into excel. Thanks so much for your help!
Day Sales
1 263
2 215
3 311
4 356
5 243
6 282
7 382
8 289
9 358
10 269
11 361
12 314
13 379
14 281
15 384
16 405
17 284
18 291
19 332
20 594
21 436
22 397
23 428
24 466
25 312
26 459
27 392
28 526
29 845
30 521
31 373
32 773
33 753
34 461
35 759
36 701
37 692
38 763
39 649
40 668
41 571
42 589
43 717
44 350
45 938
46 809
47 756
48 804
49 809
50 1305
51 996
52 701
53 872
54 877
55 701
56 869
57 835
58 789
59 722
60 786
61 1337
62 1078
63 783
64 968
65 1290
66 1704
67 1150
68 1224
69 1176
70 977
71 1019
72 1071
73 1321
74 1192
75 1009
76 1595
77 945
78 1415
79 1234
80 1574
81 1406
82 1467
83 1087
84 1600
85 1588
86 1539
87 1416
88 1416
89 1645
90 1760
91 1575
92 1713
93 1764
94 2936
95 1600
96 1809
97 1781
98 1663
99 2663
100 2020
5 Home - SRL X Mail - Rabs( X B Chapter 12 X Question 6 X Chapter 12 X G Exercise 12- X C The Owner X C The Accomp X + X C ^ ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddle.. Apps M Gmail YouTube Home - SRU @ Data Mining Flashc... @ Bus Anl 2- Final Exa... Reading list Chapter 12 Assignment i Saved Help Save & Exit Submit You received partial credit in the previous attempt. View previous attempt 6 Exercise 12-37 Static (Using Analytic Solver) The accompanying data file contains daily sales (in $) at Cafe Venetian for 100 days. For cross-validation, let the training and the 1 validation sets comprise the first 80 days and the last 20 days, respectively. points ExpictureClick here for the Excel Data File a. Use the training set to implement the Holt exponential smoothing method with two sets of user-supplied smoothing parameters, = 0.20 and B = 0.10 and a = 0.30 and B = 0.20. Compute the resulting performance measures for the validation set. (Round final Book answers to 2 decimal places.) Parameters MSE MAD Print MAPE (%) User-supplied 1 33,247.52 127.87 18.36 User-supplied 2 37,576.60 136.78 19.34 References b-1. Determine the preferred smoothing parameters for making the forecast? User-supplied 2 because of the smallest 3 out of 3 performance measures MC Type here to search Omg 5:07 PM 80OF 7/19/2021 FE5 Home - SRL X Mail - Rabs( X B Chapter 12 X Question 6 X Chapter 12 X G Exercise 12- X C The Owner X C The Accomp X + X C ^ ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddle.. Apps M Gmail YouTube S Home - SRU @ Data Mining Flashc... @ Bus Anl 2- Final Exa... Reading list Chapter 12 Assignment i Saved Help Save & Exit Submit You received partial credit in the previous attempt. View previous attempt 6 User-supplied 2 because of the smallest 3 out of 3 performance measures. 1 points Book Print n References b-2. Reestimate the preferred model with the entire data set to forecast sales for the 101st day. (Round final answer to the nearest whole number.) Forecast sales for the 101st day 2, 150 MC Type here to search Omg 5:07 PM 80OF 7/19/2021 FE