Content overview
PREPARATION: COMPUTER SOFTWARE
The main computer forecasting package used in this programme is STATISTICA in addition to the most popular spreadsheet programme found on all computers: EXCEL. Participants are required to bring their own laptops to the programme. STATISTICA will be provided beforehand and must be loaded before the programme commences. Some organisations use other forecasting software, such as EVIEWS. The various forecasting software available will however not be discussed during lecture sessions. It will be up to students to identify which software is used by their organisations and to familiarise themselves with how it works.
PREPARATION BEFORE LECTURES
- Participants should familiarise themselves with basic statistical concepts before the programme starts.
- Knowledge of EXCEL is essential since the data that will be used in computer sessions will be stored in this spreadsheet programme. Most other data manipulation tasks will also be done in EXCEL. Participants should also familiarise themselves with STATISTICA, since it is the main computer package that will be used.
- Participants are expected to go through the prescribed reading material in preparation for the lecture sessions and to attempt one or two problems at the end of each chapter. The idea is to encourage them to have an understanding of the basic forecasting concepts before classes begin. This will help speed up content coverage in class and thus leave more time for hands-on computer tasks.
TOPICS
INTRODUCTION
Basic forecasting concepts, data patterns, autocorrelation analysis, forecast evaluation measures – judgemental forecasting, managing the process.
SMOOTHING AND TECHNIQUES
Moving averages, exponential smoothing, Brown’s Method, Holt’s method,
Winter’s method.
TIME SERIES DECOMPOSITION
Trend, cycle and seasonality.
REGRESSION MODELS
Simple linear regression, multiple regression, stepwise regression, forecasting seasonal data using regression analysis, econometric forecasting.
TIME SERIES REGRESSION
Violation of OLS assumptions: Multicollinearity, autocorrelation, and heteroscedasticity
BOX-JENKINS ARIMA MODELS
Model identification, model estimation, diagnostic testing, forecasting with
the model.