Question You have to choose any cricket player, note down his last 10 matches' score. i Find the forecast for his future match using 3 period-moving average. . Find the forecast for this future match using 2 period-moving average. Solution Selected player is Rohit Sharma & this forecast is being carried out by taking his last 10 IPL Seasons Score chart. Year 2012 2013 2014 2015 Runs 433 538 390 482 489 2016 2017 2018 333 286 405 2019 2020 2021 332 138 > Calculations on next page. Period Data MA (2) MA (3) Forecasts Forecasts 2012 433 2013 538 2014 390 2015 482 2016 2016 489 2017 333 2018 286 (433+ 538)/2 = 485.5 (538+ (433+ 538 390)/2= + 390)/3 = 464 453.6667 (390+ (538 - 390 482)/2 = + 482)/3 = 436 470 (482+ (390 + 482 489)/2 = + 489)/3 = 485.5 453.6667 (489+ (482 + 489 333)2 = + 333)/3 = 411 434.6667 (333+ (489 + 333 286)/2 = + 286)/3 = 309.5 369.3333 (286+ (333 +286 405)/2 = + 405)/3 = 345.5 341.3333 (405 + (286 + 405 332)2 = +332)/3 = 368.5 341 (332+ (405 + 332 138)2 +138)/3 = 235 = 291.6667 2019 405 2020 332 2021 138 2022 i. ii. We have that for the given time series data, the forecast for 1-th period (2022) using a 3- period moving average is 291.6667. We have that for the given time series data, the forecast for 1-th period (2022) using a 2- period moving average is 235. Assignment #4 Referring to assignment # 3, you again have to take the same player selected in assignment #3. Find the forecasted score for the 11th match using the exponential smoothing method. Using alpha value as 0.3 Calculate the MAD (mean absolute deviation) for 3-period moving average forecast and the exponential smoothing method. Suggest the method based on MAD, which method is better for predicting the score of the selected player