( I did all excel part and graphs you just have to write the explanation in each excel tab please make sure you cover all points listed down also I can send old paper for same task )
Problem 11-14
1-Three-period MA (done)
- Briefly explain the technique
- What is the forcast?
2-Exp Smoothing (done)
- Briefly explain the technique
- What is the forcast?
- Briefly explain the technique
- What is the forcast?
3-Weighted moving average (use weight of 3, 2, 1 with higher weight for most recent time period) Done
4- Then compare the three furcating model and :
- Justification for best method, interpretation of summary measures?
- Briefly explain the trendlines you created
- Which trendline is better?Why?
5- Trendline – create two trendline forecasts (in separate scatterplots) showing the equation and R2
- Briefly explain the trendlines you created
- Which trendline is better?Why?
Problem 11-40
Development of mulitiplicative model (done)
- Briefly explain the technique
- Briefly discuss forecast for revenues for next four time periods
- Graph the actual and unseasonalized sales (two lines in the same graph with time on the X axis (done)
- Discussion of validity of model using summary measures
0 comments