The objective of this unit is two-fold. Initially the unit focuses on effective design and auditing of spreadsheet models, types and uses of models, and the benefits and limitations of models for use as decision support tools; various models are developed using an industry standard spreadsheet. Methods such as exploring data variations within financial models, optimisation models, probabilistic and forecasting models are covered; and emphasis placed on hypothesis testing, descriptive statistics, frequency and probability distributions, and simple linear regression and correlation. Having provided practical information analysis tools, the unit proceeds to the theoretical analysis of... -- Course Website
