Wkly Ex -6

Zola_17
Hints_for_Exercise_62.xls

C1P2

CSIS 405
Chapter 6: Time-Series Decomposition
1. Homework: Exercises 8, 9,10, 12, and 13
For this homework, choose "Decomposition" as Forecast Method
Exercise 8:
a. The forecast = (CMAT)(SI)(CF)(I)
For example, the forecast for the 1st quarter equals
(12.315+0.37 * (21))*1.24*1.01*1=25.155
Exeercise 9:
Open Forecast X, choose "Decomposition" as forecast . For "Type", choose "Multiplicative" > Reports > Audit > Finish
You will have data for answering a., b., and c.