Question: Create a multiple regression forecasting model that includes a trend component and daily seasonality dummy variables. Use Saturday as your base day. Using this estimated

Create a multiple regression forecasting model that includes a trend component and daily seasonality dummy variables. Use Saturday as your base day. Using this estimated regression equation, make a forecast for all 28 days for which you were given data. What is the MAPE over those forecasts?

Day Week Sales Volume (US$ 000s)
Sun 1 9
Mon 1 17
Tue 1 15
Wed 1 19
Thu 1 14
Fri 1 16
Sat 1 8
Sun 2 13
Mon 2 19
Tue 2 15
Wed 2 22
Thu 2 15
Fri 2 20
Sat 2 13
Sun 3 14
Mon 3 20
Tue 3 18
Wed 3 23
Thu 3 19
Fri 3 23
Sat 3 14
Sun 4 18
Mon 4 21
Tue 4 23
Wed 4 24
Thu 4 19
Fri 4 23
Sat 4 15

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 Finance Questions!