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