Homework SourseUsing the Salesdata build Moving Average with 2 and 3 period
Using the Sales-data, build:
Moving Average with 2 and 3 periods
Exponential Smoothing with an alpha, of .1 , .5 and .9
Using the Crates-data, build:
A multiple regression with trend and seasonal; forecast the next 12 months.
Moving Average with 3 periods and Exponential smoothing with .1; identify which model is best
| Year | Quarter | Sales |
| 1 | 1 | 144 |
| 2 | 151 | |
| 3 | 134 | |
| 4 | 151 | |
| 2 | 1 | 145 |
| 2 | 145 | |
| 3 | 141 | |
| 4 | 166 | |
| 3 | 1 | 151 |
| 2 | 164 | |
| 3 | 151 | |
| 4 | 176 | |
| 4 | 1 | 170 |
| 2 | 180 | |
| 3 | 156 | |
| 4 | 187 | |
| 5 | 1 | 166 |
| 2 | 182 | |
| 3 | 154 | |
| 4 | 169 |
Solution
