DFC Company has recorded the past years sales for the company: Year(t)Sales(x)(in Million Pesos)2011(1)2012(2)2013(3)2014(4)2015(5)2016(6)2017(7)2018(8)2019(9)2020(10)219224268272253284254278282298 Use the naïve model. Compute for MAE and MSEUse a three period moving average. Compute for the MAE and MSEUse the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1Use the least square method to make the forecasting table. Compute the MAE and MSE *** Use excel or r programming

Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Answered: Use the naïve model. Compute for MAE…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter14: Data Mining

Section14.2: Classification Methods

Problem 3P

Related questions

Question

Year(t)

Sales(x)

(in Million Pesos)

2011(1)

2012(2)

2013(3)

2014(4)

2015(5)

2016(6)

2017(7)

2018(8)

2019(9)

2020(10)

219

224

268

272

253

284

254

278

282

298

Use the naïve model. Compute for MAE and MSE
Use a three period moving average. Compute for the MAE and MSE
Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1
Use the least square method to make the forecasting table. Compute the MAE and MSE

*** Use excel or r programming

Expert Solution