Please explain how you arrived at the answer.
The table below illustrates the quarterly sales of swimsuits at a local retailer. Using the method shown in the text, calculate the forecast for quarter 2 in year 5.
| Year | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 |
| 25 | 75 | 125 | 75 | |
| 40 | 100 | 150 | 60 | |
| 50 | 120 | 160 | 70 | |
| 85 | 140 | 175 | 100 |
160
154
142
169
The data in the table below shows the number of attendees at Husker Water Park. Develop a linear regression to for the number of attendees based on the forecast temperature. What would be the forecasted attendance with a forecasted temperature of 88 degrees?
| Forecast Temperature | Attendance |
| 60 | 10 |
| 65 | 15 |
| 70 | 25 |
| 80 | 50 |
| 90 | 75 |
| 95 | 100 |
70
65
80
75
The table below illustrates the MAD, MAPD, and the MSE for 4 different forecasts. Which forecast method would be best to use moving forward?
| Forecast Method | MAD | MAPD | MSE |
| Moving Average | 27.2 | 9.60% | 710 |
| Weighted Moving Average | 16.4 | 5.40% | 354 |
| Exponential Smoothing | 30.7 | 10.20% | 878 |
| Regression | 24.6 | 7.80% | 576 |
Moving Average
Weighted Moving Average
Exponential Smoothing
Regression
2
