Seasonal Index Grades will be based on the answering the f
Classical Decomposition forecast methods: Create forecasts and error calc
Put answers in yellow boxes
Compute the Seasonal index (3 year average)
What is the value for QT3:
0.865455887421686
Deseasonalize the forecast (label in Excel). What is the dese
9119.41
Run Regression:
3
What is the equation for the line
y=173.51x+8047.12
4
Which equation is a better at representing the data, the one
This one because rsquared is 82%
5
How does moving forward one time period impact sales?
sales will increase or decrease by the slope
6
What is the forecast with out seasonality for 3rd QT 2020
10649.6864810351
7
What is the forecast with seasonality for 3rd QT 2020
9216.833864207
8
Why do we take seasonality out of a forecast?
so we can forecast the trend seperately then add the season
9
What is the forecast without seasonality for 2nd QT 2022
11864.2188815274
10
What is the forecast with seasonality for 2nd QT 2022
12557.2885949748
1.
2.
