moving average n=8

weighted moving average 20/20/60

exponential smoothing alpha=0.55

compute the mean absolute error and mean squared error

determine which method is best

Baby Diapers Sales Data

Weeks 2018 2019 2020

1 9,161 10,907 9,186

2 10,558 9,445 10,678

3 10,653 9,533 9,510

4 10,070 10,452 10,214

5 10,382 10,881 9,158

6 9,993 10,470 9,279

7 10,332 9,059 9,443

8 10,466 9,195 10,872

9 10,715 10,606 10,736

10 10,267 9,246 10,624

11 10,190 9,562 9,792

12 9,188 9,116 10,413

13 10,486 10,569 9,009

14 10,043 9,884 10,276

15 10,669 10,263 10,113

16 9,803 10,006 9,943

17 9,041 9,843 10,547

18 9,105 10,899 10,327

19 9,424 10,807 9,823

20 9,519 10,384 9,970

21 9,016 9,195 10,976

22 9,229 10,670 9,576

23 10,672 10,644 10,505

24 9,372 10,023 9,743

25 10,991 9,702 10,355

26 9,730 9,895 9,659

27 10,080 9,943 10,218

28 10,226 9,528 9,476

29 10,320 9,458 9,510

30 10,525 9,008 10,555

31 9,740 10,176 9,265

32 9,988 10,953 10,819

33 9,938 9,813 10,751

34 9,026 9,445 10,504

35 10,136 9,676 10,631

36 10,762 10,512 10,437

37 10,168 10,912 9,272

38 10,668 10,365 10,740

39 9,158 10,230 9,031

40 9,858 9,216 9,905

41 9,336 10,992 9,262

42 10,376 10,110 9,762

43 9,605 10,119 9,136

44 10,496 10,995 10,414

45 9,358 9,277 9,015

46 10,090 10,400 9,800

47 10,849 10,229 9,968

48 9,606 10,019 9,702

49 9,064 10,203 10,428

50 10,575 9,266 10,257

51 9,830 10,773 9,801

52 9,914 9,006 9,071

show in excel and include formulas