Question: 1 In-class practice 1.1 Basic forecasts You have monthly sales data on surfboards ranging from January 2017 to September 2018. The data is not seasonally

 1 In-class practice 1.1 Basic forecasts You have monthly sales data

1 In-class practice 1.1 Basic forecasts You have monthly sales data on surfboards ranging from January 2017 to September 2018. The data is not seasonally adjusted. Your supervisor asked you to forecast sales for the next few 3 months. The data follows. 2017-01-01 6459 2017-02-01 6527 2017-03-01 6634 2017-04-01 6816 2017-05-01 6990 2017-06-01 7157 2017-07-01 7197 2017-08-01 7228 2017-09-01 7177 2017-10-01 7182 2017-11-01 7117 2017-12-01 6970 2018-01-01 6692 2018-02-01 6799 2018-03-01 6889 2018-04-01 7081 2018-05-01 7283 2018-06-01 7442 2018-07-01 7496 2018-08-01 7525 2018-09-01 7477 The instructor will show you a time series plot of the variable and a correlogram. 1. The training set will now be set to the end of 2017. Create forecasts (mean, naive, naive with drift and seasonal naive). Which approach works best from a visual perspective? The instructor will show you the forecasts graphically. 2. Now compute the RMSE, MAE, MPE, and MAPE for each method. Which forecasting method would you use based on your measures of forecast accuracy? 3. Now make your three forecasts. One for October, November and December with your favorite method. 1 In-class practice 1.1 Basic forecasts You have monthly sales data on surfboards ranging from January 2017 to September 2018. The data is not seasonally adjusted. Your supervisor asked you to forecast sales for the next few 3 months. The data follows. 2017-01-01 6459 2017-02-01 6527 2017-03-01 6634 2017-04-01 6816 2017-05-01 6990 2017-06-01 7157 2017-07-01 7197 2017-08-01 7228 2017-09-01 7177 2017-10-01 7182 2017-11-01 7117 2017-12-01 6970 2018-01-01 6692 2018-02-01 6799 2018-03-01 6889 2018-04-01 7081 2018-05-01 7283 2018-06-01 7442 2018-07-01 7496 2018-08-01 7525 2018-09-01 7477 The instructor will show you a time series plot of the variable and a correlogram. 1. The training set will now be set to the end of 2017. Create forecasts (mean, naive, naive with drift and seasonal naive). Which approach works best from a visual perspective? The instructor will show you the forecasts graphically. 2. Now compute the RMSE, MAE, MPE, and MAPE for each method. Which forecasting method would you use based on your measures of forecast accuracy? 3. Now make your three forecasts. One for October, November and December with your favorite method

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!