Undergraduate - UnitETW1010 - Data modelling and computing

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered, or view unit timetables.

Synopsis

Introduction to principles and techniques for modelling business and economic data.
Modelling in business and finance using computers -- spreadsheet modelling of business problems, organising and accessing data efficiently. Modelling in economics and finance -- multiple regression as a tool for modelling macroeconomic and microeconomic decisions, elasticities and statistical evaluation of policy, time series modelling with application to finance. Introduction to actuarial studies as an approach to building quantitative models of risk.

Outcomes

The learning goals associated with this unit are to:

1. apply principles and techniques of data management with computers and spreadsheet modelling to business and economic decision-making problems, including profit models, breakeven analysis, sensitivity analysis, simulation, optimisation under uncertainty and network models
2. interpret and evaluate relationships between variables for business and economic decision-making using multiple linear regression, including dummy variables, functional form, trends and seasonality in time series as well as inference, confidence intervals and prediction
3. apply statistical techniques for making decisions with quantitative and categorical data in business and economics, including testing hypotheses about population mean(s), population proportion(s), one- and two-way analysis of variance, and difference between proportions in contingency tables.

Assessment

Within semester assessment: 30%
Examination (2 hours): 70%

Chief examiner(s)

Dr Lee Gordon-Brown

Contact hours

4 hours per week

Prerequisites

ETW1000

Prohibitions

ETC1010, ETC9010, ETW1031, ETW2111, ETW2010