Postgraduate Coursework Units of Study

ECMT6003 - Applied Business Forecasting

Semester 2, 2014  |  Credit Points: 6

Coordinator: Peter Exterkate
Phone: +61 2 9351 8532


This unit aims to provide an introduction to the practice of forecasting in business. Forecasting requires both practical experience in model building and some statistical theory. To blend the theory and practice, many business forecasting examples are discussed. Excel is used to do useful preliminary calculations and plotting. At the end of this unit, students should be able to understand the major techniques of forecasting and be able to intelligently forecast actual business time series using Excel and its extensions. Topics covered include: the aims of forecasting and relation to time series analysis; types of time series; plotting and charting time series; practical examples of forecasting and forecasting issues; growth curve methods; least squares (what you need to know for forecasting); decomposition of time series; elementary exponential smoothing with Excel; serial correlation (and Durbin Watson statistic); applied ARIMA modelling and identifying seasonality and "hidden" periodicities.


assignment (30%), mid-semester test (20%) and 1x2.5hr final exam (50%)


1x3-hr lecture/week



The information displayed above is indicative only as online information is subject to change without notice. The Faculty Handbook and the University of Sydney Calendar are the official legal source of information relating to study at the University of Sydney