Please state what exactly the answer is in the format given and how you get it,
ID: 3259907 • Letter: P
Question
Please state what exactly the answer is in the format given and how you get it, thanks. Also, pls consider the answer on the question if it helps, the cross means wrong, tick means correct.
Problem 15-09 With the gasoline time series data from the given table, show the exponential smoothing forecasts using = 0.1 GASOLINE SALES TIME SERIES Sales (1000s of gallons) 17 21 19 23 18 16 20 18 Week 10 15 12 a. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of = 0.1 or = 0.2 for the gasoline sales time series? Do not round your interim computations and round your final answers to two decimal places. =0.1 = 0.2 MSE 8.48 X8.23Explanation / Answer
Sales a = 0.1 a = 0.2 abs(yi -yi^) a = 0.1 abs(yi -yi^) a = 0.2 ei^2 at a = 0.1 ei^2 at a = 0.2 100*ei/yi a =0.1 100*ei/yi a =0.2 17 17 17 21 17 17 4 4 16 16 19.04761905 19.04761905 19 17.4 17.8 1.6 1.2 2.56 1.44 8.421052632 6.315789474 23 17.56 18.04 5.44 4.96 29.5936 24.6016 23.65217391 21.56521739 18 18.104 19.032 0.104 1.032 0.010816 1.065024 0.577777778 5.733333333 16 18.0936 18.8256 2.0936 2.8256 4.38316096 7.98401536 13.085 17.66 20 17.88424 18.26048 2.11576 1.73952 4.476440378 3.02592983 10.5788 8.6976 18 18.09582 18.60838 0.095816 0.608384 0.009180706 0.370131091 0.532311111 3.379911111 22 18.08623 18.48671 3.9137656 3.5132928 15.31756117 12.3432263 17.78984364 15.96951273 20 18.47761 19.18937 1.52238904 0.81063424 2.317668389 0.657127871 7.6119452 4.0531712 15 18.62985 19.35149 3.629849864 4.351492608 13.17581004 18.93548792 24.19899909 29.00995072 22 18.26686 18.48119 3.733135122 3.518805914 13.93629784 12.38199506 16.96879601 15.99457233 2.568028693 2.596339051 9.252775953 8.982230675 12.95130167 13.40242521 MAE a= 0.1 MAE a =0.2 MSE a= 0.1 MSE a= 0.2 MAPE a= 0.1 MAPE a= 0.2