Question: Given the following data for two years, visualize/plot the data and indicate the most appropriate forecasting method if you need the forecast for each month
Given the following data for two years, visualize/plot the data and indicate the most appropriate forecasting method if you need the forecast for each month of Year 4.
| Year | Month | Sales | |
| 1 | January | 1 | 5519 |
| 1 | February | 2 | 6143 |
| 1 | March | 3 | 6032 |
| 1 | April | 4 | 6513 |
| 1 | May | 5 | 6764 |
| 1 | June | 6 | 6085 |
| 1 | July | 7 | 6197 |
| 1 | August | 8 | 6709 |
| 1 | September | 9 | 6549 |
| 1 | October | 10 | 6415 |
| 1 | November | 11 | 7603 |
| 1 | December | 12 | 6803 |
| 2 | January | 13 | 7733 |
| 2 | February | 14 | 8053 |
| 2 | March | 15 | 7024 |
| 2 | April | 16 | 7675 |
| 2 | May | 17 | 7652 |
| 2 | June | 18 | 7847 |
| 2 | July | 19 | 7765 |
| 2 | August | 20 | 8566 |
| 2 | September | 21 | 9046 |
| 2 | October | 22 | 9372 |
| 2 | November | 23 | 8154 |
| 2 | December | 24 | 8956 |
| 3 | January | 25 | 8551 |
| 3 | February | 26 | 9508 |
| 3 | March | 27 | 9259 |
| 3 | April | 28 | 9294 |
| 3 | May | 29 | 9344 |
| 3 | June | 30 | 9127 |
| 3 | July | 31 | 9529 |
| 3 | August | 32 | 9294 |
| 3 | September | 33 | 9410 |
| 3 | October | 34 | 10480 |
| 3 | November | 35 | 10278 |
| 3 | December | 36 | 10423 |
Group of answer choices
1. Linear Trend (Time Series Regression) with Seasonality
2. Weighted Moving Average
3. Simple Moving Average
4. Linear Trend (Time Series Regression)
Exponential Smoothing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
