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
Get step-by-step solutions from verified subject matter experts
