Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The table below presents quarterly sales of shampoo, given in liters, over a three years period. Year Quarter Sales Forecast 1 Q1 266 1 Q2
The table below presents quarterly sales of shampoo, given in liters, over a three years period.
Year | Quarter | Sales | Forecast |
1 | Q1 | 266 | |
1 | Q2 | 143 | |
1 | Q3 | 183 | |
1 | Q4 | 119 | |
2 | Q1 | 194 | |
2 | Q2 | 161 | |
2 | Q3 | 175 | |
2 | Q4 | 140 | |
3 | Q1 | 339 | |
3 | Q2 | 250 | |
3 | Q3 | 301 | |
3 | Q4 | 221 | |
4 | Q1 | ? | |
4 | Q2 | ? | |
4 | Q3 | ? | |
4 | Q4 | ? |
- Using Linear Regression with Seasonal Adjustment, what is your forecast of shampoo sales for January of year 4? Please show the detailed calculations.
- After projecting your model in the past, calculate its Mean Absolute Percentage of Error (MAPE).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To tackle these questions well break down the process into steps Lets start with calculating the forecast of shampoo sales for Q1 of year 4 using Line...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started