Make forecast for period 25 using (i) 4 period weighted moving average with weights. W1 =0.36, w2 = 0.28, w3=0.21, w4 = 0.15; (ii) Exponential smoothing with alpha = 0.15 and F₁ = 30; and (iii) 5-period simple moving average. Use the data labelled problem # 7. Dont write the answere in Excel and if you do, you have to show the functions and workings.

Problem #7 t 00VN At 24 50 12 42 49 47 11 24 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 41 10 43 32 28 33 42 26 40 47 17 23 44 32 26 18 19 20 21 22 NNN 23 24 25 un