Question: Answer all questions and submit your final report in word file. Ensure that all steps are documented in an appropriate order, including output obtained from
- Answer all questions and submit your final report in word file.
- Ensure that all steps are documented in an appropriate order, including output obtained from calculation performed using Minitab.
Question 6 (15 marks)
Sales manager wishing to predict the future sales.
Use Sales Data to perform the following:
- Provide your comments on the sales trend.
- Provide your comments on the sales seasonality.
- Provide your comments on the obtained accuracy model.
- Predict the upcoming 3 quarter sales.
| Quarter | Sales |
| 1 | 45,000 |
| 2 | 40,000 |
| 3 | 55,000 |
| 4 | 85,000 |
| 5 | 80,000 |
| 6 | 110,000 |
| 7 | 125,000 |
| 8 | 115,000 |
| 9 | 155,000 |
| 10 | 160,000 |
| 11 | 185,000 |
| 12 | 175,000 |
| 13 | 210,000 |
| 14 | 230,000 |
| 15 | 255,000 |
| 16 | 245,000 |
| 17 | 265,000 |
| 18 | 275,000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
